Date Conversion Expression

[jpjust]

All,

I need a help here.

I have an date like this - 20201207151612 (After the date 07, it is time stamp)

I want this to be converted as 07/12/2020

Thanks

[stevejoyce · Accepted solution]

makedate(left(20201207151612 ,4), mid(20201207151612,5,2), mid(20201207151612, 7,2))

[Qlik1_User1 · Accepted solution]

Try this

DATE(Date#(Left(date,8),'YYYYMMDD'),'MM/DD/YYYY')

[jpjust]

Thanks Steve for your help.

[jpjust]

Thanks.