Format Date from 9th November 2023 to DD/MM/YY

Questions & Answers
1

Hi :slight_smile:

Wondering if it’s possible to format a date from this to DD/MM/YY

9th November 2023
1st November 2023
9th February 2023

I tried format date but it cannot understand that format.

Thanks

2

First you need to parseDate before you can formatDate

According to the Tokens you can use to parse/format a date variable, you can use Do MMMM YYYY.

e.g.: parseDate(9th November 2023;Do MMMM YYYY)

Then you can wrap that in the first parameter of formatDate:

e.g.: formatDate(parseDate(9th November 2023;Do MMMM YYYY);DD/MM/YY)

5 Likes
3

Thanks so much! Will try this!

2 Likes