Skip to main content

Date time in mapper during summer and winter time


1 comment

  • David Paras

    Since your mapping rule depends on a specific range of dates, we would suggest using the Date functions with the data mapper to create a check indicating if the offsetting value should be +1:00 or +2:00.

    Here are some possible high level steps

    1) You can grab the current date with the current date function.
    2) Create a value map containing the year and the date the time changes
    3) Use the date difference function to determine if the current date is "summer" or "winter"
    4) Use the +1:00 or +2:00 accordingly


Post is closed for comments.