Date Format

[Raj008]

Hi everyone,

I need to format the date 28-Jan-2020 to 1/28/2020, need help on this.

Thanks...

[afv2688 · Accepted solution]

Hello @Raj008 ,

You can use the following formula:

DateTimeFormat(DateTimeParse([Field1],'%d-%b-%y'),'%m/%d/%Y')

Regards