...
Dates will be stored in the YYYY-MM-DD format and time values will all be converted to a canonical UTC timezone in the XML document. Date/Time values will be converted to the XML standard YYYY-MM-DDTHH:MM:SSZ. A quick review of Coordinated Universal Time may prove to be beneficial.
UTC Quick Review
UTC time can be thought of as the time at zero degrees longitude. Timezones around the world are considered to be ahead of or behind the UTC time and are expressed with a plus (+) or minus (-) value from the UTC timezone. This plus or minus value is known as an offset. Here is a list of the UTC Timezones and offsets for your reference. Coordinated Universal Time is expressed using the 24 hour clock. UTC is sometimes referred to as Greenwich Mean Time (GMT), although they differ by fractions of a second. The term Zulu time is used by the aviation industry to refer to UTC.
Example 1: A user in the Eastern Daylight Timezone enters a time of 7:13 into a Product Order form and submits it. EDT has a UTC offset of minus 4 hours. This means that EDT timezone is 4 hours behind (west) of the UTC timezone. The offset is expressed as a -04:00. The time of 7:13 will be converted to UTC time, by adding the offset to the time. 11:13:00 will be stored in the submissions database for a value of 7:13 entered into a time or the time portion of a data/time control. The calculation is shown here: 7:13:00 AM EDT = 7:13:00 + ( 04:00) = 11:13:00 UTC
Example 2: Sydney, Australia is in the (UTC+10:00) timezone and has an offset of +10 hours from the UTC time. Sydney, Australia is 10 hours ahead (east) of the UTC timezone. The offset is expressed as a +10.00. A time of 7:13:00, entered into a form in this timezone, will be converted to UTC by subtracting the value of the offset from the time. and stored in the submissions repository. An example of the calculation is shown here: 07:13:00 AM – 10 hours = 21:13:00 UTC on the previous day.
Time in UTC format can be expressed in the XML document in two ways: Refer to this website for more information on UTC offsets.
- The time in UTC with a trailing capital "Z", which is the zone designator of the UTC time zone. For example: (11:13:00Z).
- The time followed by plus or minus the UTC offset. For Example: (07:13:00 - 04:00)
Time/Time Zone conversions can be easily done with the Time Zone Converter tool or by plugging the information into the formula: UTC Time in Zone B = Time in Zone A – (UTC offset for Zone A + UTC Offset for Zone B).
For example: Use the formula to calculate the time in India (IST) for a conference call scheduled for 8:00 AM EDT:
UTC Time in Zone B (IST in the example) = Time in Zone A - (UTC offset for Zone A + UTC Offset for Zone B),
5:30 PM (the next day) (Time in India) = 8:00 AM EDT - (-4 (offset for Zone A) + 5:30 (offset for Zone B)
&_form Tz=<tz>
The browser's time zone can be overidden by appending the &_fomTz=<tz> parameter to your form’s share URL. For Example, the timezone of a Product Order form running in the EDT timezone that has a Order Date /Time control can be changed to the PST timezone by appending the &_formTz=America/Tijuana parameter to the form's share URL. If 7:13 is entered for the time value, the time in the XML document will be stored as if the browser was running in the America/Tijuana timezone. In the example below, the T14:13:00Z represents 7:13 - EDT plus 7 hours which is the offset for the America/Tijuana timezone. See Time Zones for more information.
Submission Errors
If your submission had an error, you'll see an icon in the Err column in the submissions list. Hover over the icon to get information about the error.
...