Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
makedate(left(20201207151612 ,4), mid(20201207151612,5,2), mid(20201207151612, 7,2))
makedate(left(20201207151612 ,4), mid(20201207151612,5,2), mid(20201207151612, 7,2))
Try this
DATE(Date#(Left(date,8),'YYYYMMDD'),'MM/DD/YYYY')
Thanks Steve for your help.
Thanks.