topic Re: Date Format (repeated values) in App Development

Date Format (repeated values)

jorditorras — Mon, 23 Apr 2018 13:44:14 GMT

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

19/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 — Mon, 23 Apr 2018 14:05:38 GMT

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

YoussefBelloum — Mon, 23 Apr 2018 14:07:23 GMT

Hi,

you will need this on the script:

Date(floor([Creation Date]))

sunny_talwar — Mon, 23 Apr 2018 14:20:45 GMT

Or DayName([Creation Date])