topic Re: Greater than timestamp in QlikView

Greater than timestamp

c_latham — Sat, 21 Apr 2018 16:24:11 GMT

Hi All,

I have a CREATION_DATE field which is a timestamp. E.G. 01/01/2018 18:00:00 in the format DD/MM/YYYY hh:mm:ss

I am trying to do a simple If statement whereby the time part of the timestamp is less than 14:30:00.

My code is below, however everything gets the 'N' value no matter what the value is.

IF(time(CREATION_DATE)<='14:30:00','Y','N')

It cant be that difficult, is it?

Thanks!

sasiparupudi1 — Sat, 21 Apr 2018 16:28:19 GMT

If(Num(Frac(Timestamp#(CREATION_DATE,'D/MM/YYYY hh:mm'))<=Num(MakeTime(14,30,00)),'Y','N')

sasiparupudi1 — Sat, 21 Apr 2018 16:30:11 GMT

Looks like you were comparing num to string..

may be change

IF(time(CREATION_DATE)<=MakeTime(14,30,00),'Y','N')

c_latham — Sat, 21 Apr 2018 16:34:29 GMT

The actual answer i needed was:

If(Num(Frac(CREATION_DATE))<=Num(MakeTime(14,30,00)),'Y','N')

But I'll give it to you because you set me on the right track! Thanks!