How to format/parse date Typeform - Google sheets

How To
, ,
1

The data starts in Typeform as YYYY-MM-DD, we need it to align so the filter can find what is then in Google sheets at D-MMM-YY (Abbreviated month)
i.e.
2023-07-09
TO
9-Jul-23

2

Hi @Maya_Fitzherbert ,

You could use the formatDate time function with the time format D-MMM-YY:
{{formatDate(1.Date_1; "D-MMM-YY")}}
where 1.Date_1 is your date.

Hope it helps.

BR,

PBI

3 Likes
3

Hey Philippe, tried this one thank you, unfortunately didn’t seem to work, i.e. still recognises the date in format YYYY-MM-DD and considers it a non-match :frowning:

4

I think it should be something like this:
{{formatDate( “feild” + parseDate(“date_string”; “YYYY-MM-DD”) + “current_format”; “YYYY-MM-DD”)}}; new_format D-MMM-YY)

But I’m struggling with the order where I would put the field! Any help would be appreciated