topic Re: compare datetime in scriptside in QlikView

compare datetime in scriptside

Wed, 20 Aug 2014 04:57:36 GMT

Hi All,

I want to compare datetime field in script side fro Ex:

StDtTm is 01/10/2014 07:20:33 and EndDtTm is 12/26/2013 11:10:18

In above case I want to compare if EndDtTm > StDtTm then i want to set flag as 'Y' else 'N' as flag so how to compare it in script side.

tresB — Wed, 20 Aug 2014 05:01:31 GMT

If these datetimes are timestamps, the simple comparison should work like:

Load

If( EndDtTm > StDtTm, 'Y', 'N') as Flag

If they are text, try like:

If( Timestamp#(EndDtTm, 'MM/DD/YYYY hh:mm:ss') > Timestamp#(StDtTm, 'MM/DD/YYYY hh:mm:ss'), 'Y', 'N') as Flag

ashfaq_haseeb — Wed, 20 Aug 2014 05:02:20 GMT

Hi,

write the below code in your script.

if (EndDtTm>StDtTm,'Y','N') as Flag

Regards

ASHFAQ

Wed, 20 Aug 2014 05:11:21 GMT

Hi,

Use Something Like this

if(Timestamp#(EndTime,'MM/DD/YYYY hh:mm:ss') >timestamp#(StartTime,'MM/DD/YYYY hh:mm:ss') ,'Y','N')

Regards,

Vivek

jagan — Wed, 20 Aug 2014 05:20:10 GMT

Hi,

Try like this

LOAD

If(EndDtTm > StDtTm, 'Y', 'N') AS Flag

FROM DataSource;

If above not working then try like this

LOAD

If(Timestamp#(EndDtTm ,'MM/DD/YYYY hh:mm:ss') >Timestamp#(StDtTm,'MM/DD/YYYY hh:mm:ss') ,'Y','N')

FROM DataSource;

Hope this helps you.

Regards,

Jagan.

PrashantSangle — Wed, 20 Aug 2014 05:33:13 GMT

Hi,

It is better if convert it number while compare

Try like,

if(Num(Timestamp(Timestamp#(EndTime,'MM/DD/YYYY hh:mm:ss'))) >Num(Timestamp(timestamp#(StartTime,'MM/DD/YYYY hh:mm:ss'))) ,'Y','N') as Flag

Regards