2 Replies Latest reply on Feb 10, 2017 5:31 AM by Gabriel Belba

    Compare DateTime with a string value

    Gabriel Belba



      I have two dimensions, one is a date and other is for time. The idea was to calculate a local date and time which is different that server time (9 hours difference). I find a solution to calculate this and is ok.


      Based on this local Date and Time I need to calculate the time for all 3 shifts based on next criteria:


      Shift_1 between 06:00:00 - 14:00:00

      Shift_2 between 14:01:00 - 22:00:00

      Shift_3 between 22:01:00 - 05:59:00


      First I extract the time which works as a string, but forward I don't find any solution to make it happen.


      Has someone any idea how to achieve this?


      Thanks in advance