Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have attached date format...How to convert that to regular date ?
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
There are two formats in your screenshot.
Which one is your source format?
Besides your source format, one solution to convert a timestamp into a date is the Dayname() function.
hope this helps
regards
Marco
Use Date(Floor(Date),'YYYY-MM-DD')