Forum Discussion

ScottPugh's avatar
ScottPugh
Qrew Cadet
6 years ago

Entering Date/Time values that include a timezone offset into Date/Time fields?

I have the need to handle imported date/time values that include timezone offsets

I'm hoping at least one of the following is possible:
1. Store the complete date/time value including the timezone offset  (thus far it always seems to take the time portion but then drops the timezone offset)
2. Have QB adjust all date/times entered to a 'common' timezone such as UTC or the user local timezone (again taking into account the timezone offset)

Examples of date/time entries are

2019-03-28T18:06:11.072+01:00   
2019-04-20T13:26:12.133-05:00

Do i need to modify this format in someway before saving in a date/Time field so that it retains the timezone offset?

Thank you.
Formulas and functions
Tables and fields
  • QuickBaseCoachD's avatar
    QuickBaseCoachD
    Qrew Captain
    6 years ago
    You will need to take in that raw data into a field.
    Then parse out the date and the time and the offset into either three fields or done by formula variables inside a formula date time field.

    Then build a formula do what you want with that info.

    ie, Quick Base will not magically recognize that syntax.

    Post back if you need help to parse out the components into three fields.