Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
If you are a Qlik Insight Bot user, join this collaborative group: JOIN GROUP
Highlighted
Anonymous
Not applicable

Date comparison (without time&hour)

Hello,

I've stored two dates in my DB in the classic Date&Time format and I'd like to compare them not considering the Time part, but only the day one  (eg 23/10/17 13:30 should be compared with 23/10/17 13:31 and the result must be that they are equals).

Thank you for the help.

N.

2 Replies
Valued Contributor II

Re: Date comparison (without time&hour)

Dayname(Date1) = Dayname(Date2) is easiest. You could also use Floor(), or any number of other options.

Highlighted
Anonymous
Not applicable

Re: Date comparison (without time&hour)

Thank you Shoham for the prompt reply and for the aswer!

I've lost a lot of time looking for it!

N.