topic Re: Date Conversion Expression in App Development

Date Conversion Expression

jpjust — Thu, 26 Aug 2021 16:23:12 GMT

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 — Thu, 26 Aug 2021 16:28:30 GMT

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

Qlik1_User1 — Thu, 26 Aug 2021 16:29:02 GMT

Try this

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

jpjust — Thu, 26 Aug 2021 16:37:31 GMT

Thanks Steve for your help.

jpjust — Thu, 26 Aug 2021 16:38:01 GMT

Thanks.