topic Re: Comparing 2 Dates in QlikView

Comparing 2 Dates

microwin88x — Sun, 19 Jan 2014 21:35:48 GMT

Hello. I have 2 dates: CREATION_DATE (DD/MM/YYYY hh:mm:ss) and END_DATE (DD/MM/YYYY hh:mm:ss)

1. How could I compare if both dates are in the same day? (I need a function for the script)

2. How could I compare if (END_DATE - CREATION_DATE) > 16 hours ???

I really need your help. Thanks!!

swuehl — Sun, 19 Jan 2014 22:14:02 GMT

SET TimestampFormat='DD/MM/YYYY hh:mm:ss[.fff]';

LOAD

CREATION_DATE,

END_DATE,

if(daystart(CREATION_DATE)=daystart(END_DATE), 1,0) as SameDateFlag,

if(day(CREATION_DATE) = day(END_DATE), 1,0) as SameDayFlag,

if( END_DATE - CREATION_DATE > maketime(16), 1,0 ) as MoreThan16HoursFlag

FROM ...;

hic — Sun, 19 Jan 2014 22:15:27 GMT

If they are, you can use

HIC