Open topic with navigation

# DateOffset

The offset to apply to the document date when rounding to the specified DatePeriod. By default, IDOL aligns the DatePeriod to its system time. Use `DateOffset` to align the DatePeriod to a different start point, such as the local timezone boundaries for users in different timezones.

You can use one of the following formats to specify the offset:

- An offset in seconds. You can use negative numbers to specify a negative offset. For example, `DateOffset=-19800&DatePeriod=day` uses `18:30:00 UTC` as the start of a day, which is `00:00:00 IST`.

- A comma-separated list of values in the format `NSeconds,NMinutes,Nhours,Ndays,Nmonths,Nyears,` where `NSeconds` is the number of seconds to offset, `NMinutes` is the number of minutes to offset, and so on.

  You do not have to specify all these values. For example, if `DateOffset` is `0,0,0,5,3`, the date is offset by five days and three months so that the beginning of a year is 6 April, which is the UK tax year.

- A timezone or location value. For a full list of the available timezones, see DateOffset Timezone List. For example, `Asia:Calcutta` gives a UTC offset of +05:30, which is equivalent to `DateOffset=-19800`.

  You can add `:DST` to a timezone string to offset for that timezone with daylight savings time. For example: `Australia:Adelaide:DST`.

Actions: | GetQueryTagValues
Type: | String
Default: |
Example: | `DateOffset=0,0,0,5,3`
See Also: | DatePeriod

© 2017 Hewlett Packard Enterprise Development LP | Send documentation feedback to HPE Close Send documentation feedback To open the configured email client on this computer, open an email window. Otherwise, copy the information below to a web mail client, and send this email to AutonomyTPFeedback@hpe.com. We appreciate your feedback! Product: Topic Title: Help Topic: Feedback:

_HP_HTML5_bannerTitle.htm