Date format

[memela]

Hi 

I have a data with a  date on TimeStamp formatted like this " YYYY/MM/DD hh/mm/dd", I to first separate the date and time. Date and Time fields. I want to analyze the data only using the Date but its not possible when using the TimeStamp. Even if i change the Time stamp format to "YYYY/MM/DD) it doesn't help

[durgesh22 · Accepted solution]

Try below it might help.

Date(Floor(YourDateField),'YYYY/MM/DD'))

[memela]

Thank you. It worked.