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)?


      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