Adjust Timestamps for TimeDifference between UTC and CET

Comments

2 comments

  • Avatar
    Michael Becker

    Hi Christopher,

    I would approach it this way:

    1 - create a custom column on table with UTC timestamp which will extract month (GetMonth[departure_time_UTC])

    2- create second custom column which would use:

    CASE

    WHEN [first column] > 10 OR [first column] < 4 THEN AddMinutes(s.[departure_time_UTC],60)

    WHEN [first column] <= 10 OR [first column] >= 4 THEN AddMinutes(s.[departure_time_UTC],120)

    ELSE [departure_time_UTC]

    END

     

    This should take care of your case I think(might require some fine tuning as I have not seen your exact structure there). By the way are you okay with few days being misaligned since Daylight Saving change does not take place exactly at the end of the month ?

    Regards,

    Michał

     

    0
    Comment actions Permalink
  • Avatar
    Christopher Hols

    Thank you!

     

    Yes I already considered the difference every year, it is acceptable since it is usually only a couple of days off

    0
    Comment actions Permalink

Please sign in to leave a comment.