topic Re: Make date Condition in QlikView

Make date Condition

Prabhu1204 — Wed, 25 Nov 2020 16:16:04 GMT

Hello,

I have a make date condition in Qlikview

" MakeDate(LEFT(Timestamp,4), MID(Timestamp,6,2), MID(Timestamp,9,2)) as Date" when I run the script the dates are getting populated in Date filed. But when i tried to use the same expression in text box, I am not geetting the date, instead i am getting "-".

Taking timestamp from the .csv file. For text box , i used the timestamp value directly " 20190723T130840.000-0500"

Can you clear me this

Re: Make date Condition

jonathandienst — Fri, 28 Feb 2020 05:03:47 GMT

Try this instead:

Date(Date#(Left(TimeStamp, 8), 'YYYYMMDD'))

Re: Make date Condition

Prabhu1204 — Fri, 28 Feb 2020 05:09:00 GMT

It works,, Thank you..

but how it works(The condition which i posted) in Script and not in text box expression? any reason behind it ?

Re: Make date Condition

jonathandienst — Fri, 28 Feb 2020 05:19:55 GMT

Your expression could not have worked in any environment based on the information you provided. If you believe it worked somewhere, then something else was going on.

The expresssion was attempting this MakeDate():

MakeDate(2019, 72, 'T1')

which is plainly not valid.