Comparing 2 Dates

[microwin88x]

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]

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]

First, you need to make sure that both dates are interpreted correctly. See http://community.qlik.com/blogs/qlikviewdesignblog/2013/02/19/why-don-t-my-dates-work

If they are, you can use

1. If(Floor(CREATION_DATE)=Floor(END_DATE), ... )
2. Fabs(CREATION_DATE-END_DATE) <= 16/24

HIC