Error parsing date

[Ken_Walton]

Hi there, I have an output which returns a date in the format ‘31 Mar 24’ which I want to parse as a date and then format as YYYY-MM-dd. I am not sure what I doing wrong but keep getting the error “Failed to map ‘value’: Function ‘parseDate’ finished with error! ‘31 Mar 24’ is not a valid date or does not match the date format.”

Thanks in advance

Ken

[dilipborad]

Hello @Ken_Walton
Use this set of functions.
{{formatDate(parseDate("31 Mar 24"; "DD MMM YY"); "YYYY-MM-DD")}}

[Ken_Walton]

Thank you - I have already tried that syntax and get the following error:

[dilipborad]

Hello Ken,
Sorry, I’ve made a mistake in the written formula.
Just updated it on the previous post and also wrote it down formula here.

{{formatDate(parseDate("31 Mar 24"; "DD MMM YY"); "YYYY-MM-DD")}}

[Ken_Walton]

@dilipborad

{{formatDate(parseDate(“31 Mar 24”; “DD MMM YY”); “YYYY-MM-DD”)}}

Amazing - thank you