Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

hammermill21
Contributor II

Grouping Dates with different timestamps

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

1 Solution

Accepted Solutions
MVP
MVP

Re: Grouping Dates with different timestamps

Try this

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

5 Replies
MVP
MVP

Re: Grouping Dates with different timestamps

Try this

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

atkinsow
Valued Contributor II

Re: Grouping Dates with different timestamps

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
Contributor II

Re: Grouping Dates with different timestamps

Thank you as always!!!

hammermill21
Contributor II

Re: Grouping Dates with different timestamps

Thank you as always!!!

hammermill21
Contributor II

Re: Grouping Dates with different timestamps

Got it, thank you! Foolish mistake!