2 Replies Latest reply: Jun 16, 2017 10:23 AM by Yifan Wu RSS

    How to convert strings like 10:00am or 10am to timestamp in Qlik Sense?

    Yifan Wu

      Hi,

      I have two fields,One is a datetime field that stores the date value and one is a varchar, that stores the time value. But since it is a varchar, there are values like 10am, 10:00am, 10:00 am and 10..Is there anyway I can convert this varchar value to a timestamp and the combine it with the date field? My ultimate goal is to have a field with the actual date time and one with the date time value in a different timezone based on state value.

       

      Thank you!