Date time in mapper during summer and winter time

David Paras

• February 10, 2015 17:25

During summer and winter period our clock has 1 hour difference. In a mapping we try to create a value like this:

2015-01-05T11:41:36+01:00

+01:00 indicates the difference with GMT, but during summer and winter time it switches from +01:00 to +02:00. How can we add this automatically to the datetime value?

0

• 

  David Paras

  • February 10, 2015 17:25

  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

  0

Post is closed for comments.