Timezone and Date Time Pattern

Lets say you are in Manila (Philippines) .You included the {{ Response Date }} in your Email body template because you wanted to check when the form was submitted every time a new response came in. How would the data be shown in the Email ? You will see Response date as 2021-06-03T19:51:04.558Z .This is because the add-on does not know about your Timezone and the Date Time pattern you want the data in .So the add-on processes the data in ETC/GMT Timezone and its own Date Time Pattern.

Now the add-on allows you to set your Time zone and Date Time Pattern options so that this can be displayed in the pattern of your choice .Head over to Troubleshoot menu with in the add on and you should see an option to set up your preferred Timezone and Date Time Pattern.

What Date Time Pattern To use

Sample Date Time Patterns

  • Using yyyy.MM.dd G 'at' HH:mm:ss z will produce a result similar to 2001.07.04 AD at 12:08:56 PDT

  • Using EEE, MMM d, ''yy will produce a result similar to Wed, Jul 4, '01

  • Using h:mm a will produce a result similar to 12:08 PM

  • Using hh 'o''clock' a, zzzz will produce a result similar to 12 o'clock PM, Pacific Daylight Time

  • Using K:mm a, z will produce a result similar to 0:08 PM, PDT

  • Using yyyyy.MMMMM.dd GGG hh:mm aaa will produce a result similar to 02001.July.04 AD 12:08 PM

  • Using EEE, d MMM yyyy HH:mm:ss Z will produce a result similar to Wed, 4 Jul 2001 12:08:56 -0700

  • Using yyMMddHHmmssZ will produce a result similar to 010704120856-0700

  • Using yyyy-MM-dd'T'HH:mm:ss.SSSZ will produce a result similar to 2001-07-04T12:08:56.235-0700

  • Using yyyy-MM-dd'T'HH:mm:ss.SSSXXX will produce a result similar to 2001-07-04T12:08:56.235-07:00

  • Using YYYY-'W'ww-u will produce a result similar to 2001-W27-3


Note:

  • The above information has been reproduced from date time patterns and more patterns can be formed by following the same guidelines.

  • In case the format or time zone is missing the add-on falls back to the default Timezone and format.

  • In future we plan to use the same Timezone and Pattern settings for other form fields which represent Dates.

Previous

QRCode