Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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!!
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 ...;
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
HIC