Make date Condition

[Prabhu1204]

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

[jonathandienst · Accepted solution]

Try this instead:

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

[Prabhu1204]

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 ?

[jonathandienst]

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.