Converting time out of a date stamp

[joe_mccorkel]

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!

[Anonymous · Accepted solution]

Try something like:

     ==time(time#(right(20180129235900,6),'hhmmss'),'h:mm:ss TT')

[joe_mccorkel]

That worked great, thanks Bill!