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

    Compare DateTime with a string value

    Gabriel Belba

      Hi,

       

      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