Grouping Dates with different timestamps

[hammermill21]

Hello!

I am pulling dates that contain timestamps, I use this expression to remove the timestamps - =Date([CREATED DATE], 'MMM DD, YYYY') but now I have 30 inspection dates for Jul 12, 2017. I want to group all those together, how could I do this?

Thanks!

Using: QlikSense Enterprise

[sunny_talwar · Accepted solution]

Try this

=Date(Floor([CREATED DATE]), 'MMM DD, YYYY')

[Anonymous]

Sunny is correct.  Just using the Date function doesn't actually remove the time portion of the timestamp it just formats it.

You need to use a function like FLOOR in order to actually remove the time from the field.

[hammermill21]

Thank you as always!!!

[hammermill21]

Thank you as always!!!

[hammermill21]

Got it, thank you! Foolish mistake!