Date Not converting in YYYY-MM-DD

[Srawat]

Hi,

I am trying to convert date YYYY-MM-DD by using formula tool. however not changing the format. Please advise.

Thanks,

Rajeev

[DavidSkaife · Accepted solution]

Hi @Srawat 

You need to change the format to match what format the date is currently in, so for your example you would need DateTimeParse([Date],'%m/%d/%Y')

[Emmanuel_G]

@Srawat 

In attachement the way of doing that.

[Srawat]

Thanks! get the date format.