1 Reply Latest reply on Oct 17, 2017 9:11 AM by patrick.byrne.0

    Daylight savings with diferent utc

    Roger Joan

      Good morning,

      Im trying to make a daylight saving calculated field,

      But when im printing it at colums, i think its making all zones movements at same time, producing errors.

       

      Values are correct. Theres a +1 each 30 minutes.

      Filters values between 2 dates.

      The only problem its the hour jump on 2:00 to 3:00

       

      the calculated field:

       

      Date DaySaved Europe

      IF

      //Example :last Sunday in March at 1AM

      [Final date] >= DATEADD('hour',(DATEPART('hour',[Hour start])),DATEADD('week',([Week start]-4),(DATETRUNC('week',DATEADD('month',[Month start],DATETRUNC('year',[Final date]))))))

      AND

      //Example: last Sunday in October at 2AM

      [Final date] < DATEADD('hour',(DATEPART('hour',[Hour end])),DATEADD('week',([Week end]-4),(DATETRUNC('week',DATEADD('month',[Month end],DATETRUNC('year',[Final date]))))))

      THEN DATEADD('hour',(-[UTC]+1),[Final date])

      ELSE DATEADD('hour',(-[UTC]),[Final date])

      END

       

      Error Fechas2.PNG

      The first 3:00 and 3:30 at the photo should be 2:00 and 2:30, dont know why it jumps 2 hours instead of 1. (12:30->2:00 instead of 12:30->3:00)

       

      Anyone know whats happening?

      Thanks in advance.