2 Replies Latest reply: Feb 20, 2018 4:12 PM by Joe McCorkel RSS

    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!