Converting / Parsing Text / Date in Format DD-MMM-YYYY

Questions & Answers
, ,
1

Hi there :blush:

I’m getting a Date value from a Google sheet and eventually trying to push into a Monday board.

The date is coming (probably) as text in a DD-MMM-YYYY Format e.g. 16-Nov-2023 and I believe Monday needs YYYY/MM/DD or something similar (I used DD-MM-YYYY in the screenshot below).

image
image1021×290 19.1 KB

The problem is that the formatDate Function doesn’t recognized it as a date so i’m getting an Error
image

Any clues on how to format DD-MMM-YYYY text into a date?

Many thanks ! :disguised_face:

2

You need to use parseDate first with the current date format, then formatDate into the date format you want.

formatDate( parseDate(date_string; current_format); new_format )

See: Date Format Tokens

4 Likes
3

Hi,

The monday.com Date format is YYYY-MM-DD

Hope this helps

2 Likes
4

Wow Sam, amazing as always, it worked !

ParseDate to let Make know what is the format, then formatDate to convert to another date format.

:trophy: :hugs:

5

If you want to learn more about Make, you can read up in the Help Center. I also recommend doing the tutorials in the Make Academy, and learn advanced skills like how to make custom apps to any API in the Make Partner Training Portal - both have certificates for successful completion.

2 Likes