Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Try below it might help.
Date(Floor(YourDateField),'YYYY/MM/DD'))
Thank you. It worked.