Date Format (repeated values)

[jorditorras]

Dear Gurus,

We have a QlikSense Application and I want to add a new field related to "Date". Each record have a format like this:

dd:mm:aaaa hh:mm:ss

For example:

Creation Date:

18/04/2018 12:01:15

18/04/2018 18:14:54

19/04/2018 10:02:33

19/04/2018 11:45:15

19/04/2018 12:24:05

20/04/2018 09:54:34

20/04/2018 13:52:54

20/04/2018 19:43:05

I'm loading this field in the script like:

Date (Creation Date)

The problem is that after loading the data, it returns the following values:

18/04/2018

18/04/2018

18/04/2018

19/04/2018

19/04/2018

19/04/2018

20/04/2018

20/04/2018

20/04/2018

And I want to group the repeated values. So, I'd have to get:

18/04/2018

19/04/2018

20/04/2018

Any idea of how to handle it?

Thanks!!

[rsdhavle]

Try  Date(Date#(CreationDate),'DD/MM/YYYY')  if it works

[YoussefBelloum]

Hi,

you will need this on the script:

Date(floor([Creation Date]))

[sunny_talwar · Accepted solution]

Or DayName([Creation Date])