topic Re: Date format in QlikView

Date format

memela — Tue, 10 May 2022 07:30:54 GMT

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

Re: Date format

durgesh22 — Tue, 10 May 2022 07:40:35 GMT

Try below it might help.

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

Re: Date format

memela — Tue, 10 May 2022 08:32:16 GMT

Thank you. It worked.