Date format

[apthansh]

I have attached date format...How to convert that to regular date ?

[adityaakshaya]

Hi Ansh,

Lets say we have a date field EgDate.

Date( Floor( Timestamp#( EgDate, 'YYYY-MM-DD hh:mm:ss')), 'M/D/YYYY') as ModifiedDate.

Regards,

Akshaya

[MarcoWedel]

There are two formats in your screenshot.

Which one is your source format?

[MarcoWedel]

Besides your source format, one solution to convert a timestamp into a date is the Dayname() function.

hope this helps

regards

Marco

[sasiparupudi1]

Use Date(Floor(Date),'YYYY-MM-DD')