# Date formatting issue

**URL:** <https://community.make.com/t/date-formatting-issue/47121>\
**Category:** Questions\
**Tags:** format-date\
**Created:** [July 22, 2024, 12:10am UTC](https://community.make.com/t/date-formatting-issue/47121 "2024-07-22T00:10:52Z")\
**Posts on this page:** 7\
**Page:** 1

<div class="post-metadata">

**Author:** ![Ivan\_Hincapie](https://avatars.discourse-cdn.com/v4/letter/i/34f0e0/32.png) [@Ivan\_Hincapie](https://community.make.com/u/Ivan_Hincapie)\
**Post date:** [July 22, 2024, 12:10am UTC](https://community.make.com/t/date-formatting-issue/47121/1 "2024-07-22T00:10:52Z")

</div>

So I am parsing the date like this:  
 ![image](https://europe1.discourse-cdn.com/flex013/uploads/make/original/3X/0/d/0d83cc11b7adaf794effc6e216996eb0da286a23.png)

And the this is how I am trying to format the date:  
 ![image](https://europe1.discourse-cdn.com/flex013/uploads/make/original/3X/8/a/8a309964867949488bbf491d6db99ce69033c118.png)

Nonetheless I am getting this error:  
 ![image](https://europe1.discourse-cdn.com/flex013/uploads/make/original/3X/3/5/35c8830e36a4c8629346c31b2d8142549e7a8154.png)

I think I am in the right path, but not sure what could i be missing. Will appreciate any advise from the community! Thank you!

---

<div class="post-metadata">

**Author:** ![Donald\_Mitchell](https://dub1.discourse-cdn.com/flex013/user_avatar/community.make.com/donald_mitchell/32/8749_2.png) [@Donald\_Mitchell](https://community.make.com/u/Donald_Mitchell)\
**Post date:** [July 22, 2024, 1:30am UTC](https://community.make.com/t/date-formatting-issue/47121/2 "2024-07-22T01:30:58Z")

</div>

Hello @Ivan_Hincapie and welcome to the Make Community!

Since value is currently a string, you’ll need to use parseDate() first to convert it to a date.  
Then, you can use formatDate() to format it differently for display purposes.

---

<div class="post-metadata">

**Author:** ![Ivan\_Hincapie](https://avatars.discourse-cdn.com/v4/letter/i/34f0e0/32.png) [@Ivan\_Hincapie](https://community.make.com/u/Ivan_Hincapie)\
**Post date:** [July 22, 2024, 3:37pm UTC](https://community.make.com/t/date-formatting-issue/47121/3 "2024-07-22T15:37:42Z")

</div>

Thank you, that removed the error, but the output is empty  
 ![image](https://europe1.discourse-cdn.com/flex013/uploads/make/original/3X/c/9/c913f3c1be45f09c1083e2777eda504d83e74d21.png)  
Do you have any suggestions there?

---

<div class="post-metadata">

**Author:** ![Donald\_Mitchell](https://dub1.discourse-cdn.com/flex013/user_avatar/community.make.com/donald_mitchell/32/8749_2.png) [@Donald\_Mitchell](https://community.make.com/u/Donald_Mitchell)\
**Post date:** [July 22, 2024, 4:01pm UTC](https://community.make.com/t/date-formatting-issue/47121/4 "2024-07-22T16:01:06Z")

</div>

Can you show your parseDate() function?  
It returned nothing so the function might not have the correct syntax.

---

<div class="post-metadata">

**Author:** ![Ivan\_Hincapie](https://avatars.discourse-cdn.com/v4/letter/i/34f0e0/32.png) [@Ivan\_Hincapie](https://community.make.com/u/Ivan_Hincapie)\
**Post date:** [July 22, 2024, 4:09pm UTC](https://community.make.com/t/date-formatting-issue/47121/5 "2024-07-22T16:09:06Z")

</div>

@Donald_Mitchell sure, thank you, here it is:

![image](https://europe1.discourse-cdn.com/flex013/uploads/make/original/3X/3/5/35c9038b808ec34288e0ce9e803b928f1ea15a72.png)

---

<div class="post-metadata">

**Author:** ![Donald\_Mitchell](https://dub1.discourse-cdn.com/flex013/user_avatar/community.make.com/donald_mitchell/32/8749_2.png) [@Donald\_Mitchell](https://community.make.com/u/Donald_Mitchell)\
**Post date:** [July 22, 2024, 4:15pm UTC](https://community.make.com/t/date-formatting-issue/47121/6 "2024-07-22T16:15:11Z")

</div>

parseDate() takes two parameters  
 ![image](https://europe1.discourse-cdn.com/flex013/uploads/make/original/3X/8/b/8b5a598b6d226a591779c507dd7fa48b17fa9c7d.png)

After pick\_date, try adding a semi-colon then the format of the date you’ve supplied, like MMMM DD, YYYY.

---

<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:** [August 7, 2024, 11:04pm UTC](https://community.make.com/t/date-formatting-issue/47121/7 "2024-08-07T23:04:16Z")

</div>


