topic Convert dates to a common format. in App Development

Convert dates to a common format.

sujit_nath — Sat, 19 Jun 2021 18:33:17 GMT

I have date like this:

Date

June-20-2018

Jun-19-09

01-12-2020

20-02-2020

How do I convert them in a common format? say dd-mm-yyyy.

Re: Convert dates to a common format.

jwjackso — Sat, 19 Jun 2021 20:36:51 GMT

Use the Alt() function

=Date(Alt(Num(Date#([Date],'MMM-DD-YYYY')),Num(Date#([Date],'MMM-DD-YY')),Num(Date#([Date],'MM-DD-YYYY')),Num(Date#([Date],'DD-MM-YYYY'))),'DD-MM-YYYY')

Re: Convert dates to a common format.

Vegar — Sat, 19 Jun 2021 22:09:58 GMT

the suggestion by @jwjackso will work in many cases, but not if your column could contain both 'MM-DD-YYYY' and 'DD-MM-YYYY' as you can by no means know you just looking at eg. 06-12-2021 identify the format. It will return a date value using any of the two patterns. It could be 12th of June or the 6th of December, you can't tell which.