1 Reply Latest reply: Aug 17, 2016 8:51 PM by Sunny Talwar RSS

    Finding difference of 2 date/time fields that contain UTC Offset

    Greg Wessels

      Hello All,

       

      I am trying to find the difference between an OrderDate and ReceiveDate in minutes so I can graph the avg difference by time of day. I understand the way to do this is by using "interval."

       

      What is making this more difficult is that the date times are in the following format YYYY-MM-DD hh:mm:ss[.FFFFFFFFF]-HH:MM

       

      Does anyone have pointers on how I can get Qlik Sense to understand my format is a date/time?

       

      Thanks,

      Greg