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?
Using: QlikSense Enterprise
=Date(Floor([CREATED DATE]), 'MMM DD, YYYY')
Thank you as always!!!
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.
Got it, thank you! Foolish mistake!
Retrieving data ...