3 Replies Latest reply: Feb 5, 2018 7:51 AM by Sunny Talwar RSS

    Convert string into time?

    William Fu

      How can convert a string into a timestamp (hh:mm)?

      e.g.:

      1531 into 15:31

      0805 into 08:05

       

      This code doesn't seem to work:

          Time(Time#([String], 'hh:mm') ) AS [StringHour],

       

      After that, how would I combine it with a date to create a date/time column?

       

      Thanks in advance