# How do I parse and format this date so Notion can recognize it as a date in it's calendar view

**URL:** <https://community.make.com/t/how-do-i-parse-and-format-this-date-so-notion-can-recognize-it-as-a-date-in-its-calendar-view/22567>\
**Category:** Questions\
**Tags:** notion, functions\
**Created:** [December 23, 2023, 11:38pm UTC](https://community.make.com/t/how-do-i-parse-and-format-this-date-so-notion-can-recognize-it-as-a-date-in-its-calendar-view/22567 "2023-12-23T23:38:13Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![DISCURSIVAS\_EDUCACAO](https://avatars.discourse-cdn.com/v4/letter/d/3ec8ea/32.png) [@DISCURSIVAS\_EDUCACAO](https://community.make.com/u/DISCURSIVAS_EDUCACAO)\
**Post date:** [December 23, 2023, 11:38pm UTC](https://community.make.com/t/how-do-i-parse-and-format-this-date-so-notion-can-recognize-it-as-a-date-in-its-calendar-view/22567/1 "2023-12-23T23:38:13Z")

</div>

Hi there,

I have a variable presented in the YYYYMMDD format within a string, and I’m looking to convert it into the DD/MM/YYYY format for Notion to identify it as a date.

Could you please advise on the best approach for this? I attempted to use the “Set Variable” tool to format it, but I’m not confident in my coding skills.

Thank you in advance!

 ![Captura de tela 2023-12-23 203444](https://europe1.discourse-cdn.com/flex013/uploads/make/original/3X/1/5/152428cd9bb1bce0d09f526e191ca5e06f88c46c.png)

---

<div class="post-metadata">

**Author:** ![Msquare\_Automation](https://dub1.discourse-cdn.com/flex013/user_avatar/community.make.com/msquare_automation/32/6634_2.png) [@Msquare\_Automation](https://community.make.com/u/Msquare_Automation)\
**Post date:** [December 24, 2023, 3:45am UTC](https://community.make.com/t/how-do-i-parse-and-format-this-date-so-notion-can-recognize-it-as-a-date-in-its-calendar-view/22567/2 "2023-12-24T03:45:52Z")

</div>

Hi @DISCURSIVAS_EDUCACAO

The given formatted date can be converted to a date datatype using the parseDate() function.  
Eg: parseDate(InputDate;YYYYMMDD)

Now, you can format as per your requirement using the formatDate() function.

[MSquare Support](https://calendly.com/msquarepro/meeting)  
Visit us [here](https://www.msquare.pro/)  
[Youtube Channel](https://www.youtube.com/channel/UCqidlIIwbejxZmRUWBICcjQ)

---

<div class="post-metadata">

**Author:** ![DISCURSIVAS\_EDUCACAO](https://avatars.discourse-cdn.com/v4/letter/d/3ec8ea/32.png) [@DISCURSIVAS\_EDUCACAO](https://community.make.com/u/DISCURSIVAS_EDUCACAO)\
**Post date:** [December 26, 2023, 6:12pm UTC](https://community.make.com/t/how-do-i-parse-and-format-this-date-so-notion-can-recognize-it-as-a-date-in-its-calendar-view/22567/3 "2023-12-26T18:12:17Z")

</div>

Thank you. Your answer was crucial for me in finding the way to pass through it - simple and objective. I’m posting the screenshots below so that everyone in the same situation can solve it too.

 ![1111](https://europe1.discourse-cdn.com/flex013/uploads/make/original/3X/0/8/082e38fdf3e6b9bb848a08d6095c66bcf3e57c48.png)  
 ![2222](https://europe1.discourse-cdn.com/flex013/uploads/make/original/3X/d/5/d55ead9a4c2566ef7b32196b1c56f77a764b3677.png)  
 ![3333](https://europe1.discourse-cdn.com/flex013/uploads/make/original/3X/b/5/b5245edfad202ba46baa6387d50cb4cea37aaf8b.png)

---

<div class="post-metadata">

**Author:** ![Make\_Bot](https://dub1.discourse-cdn.com/flex013/user_avatar/community.make.com/make_bot/32/14661_2.png) [@Make\_Bot](https://community.make.com/u/Make_Bot)\
**Post date:** [January 9, 2024, 6:27pm UTC](https://community.make.com/t/how-do-i-parse-and-format-this-date-so-notion-can-recognize-it-as-a-date-in-its-calendar-view/22567/4 "2024-01-09T18:27:04Z")

</div>