Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello- I am tryilng to convert the time section of a date stamp that looks like '20180129060000' to be 6:00:00AM, or '20180129235900' to be 23:59:00/ 11:59PM. Ive tried using date(rignt('date',6)) and date(date#(right('date',6))). the first returns 12:00:00AM every time, and the second returns null. Any thoughts?
Thanks!
Try something like:
==time(time#(right(20180129235900,6),'hhmmss'),'h:mm:ss TT')
Try something like:
==time(time#(right(20180129235900,6),'hhmmss'),'h:mm:ss TT')
That worked great, thanks Bill!