Hi Everyone,
Can you help me figure out a date, time zone issue?
I import a .csv file that has a “Created Date” field value of “2020-06-05T01:52:41Z”
The import works great, but I noticed the date that appears in my Form is usually a day off, when compared to the original date on my website, before it’s exported to a .csv file.
After a little research, I found out the .csv file is being exported using the UTC+0 time zone. So, does anyone know a calculation that can change this UTC+0 value, “2020-06-05T01:52:41Z” to a Pacific Daylight Time equivalent?
Try changing the Z to be +07:00 or similar. Tap Forms internally stores the dates in UTC+0 but will convert to your local time zone. Alternatively use a form script to change the time but probably best to do during import.
Hi Sam,
Thanks for the tips. The more I learn about Tap Forms, the more I realize I need to learn…
So now I understand what the “Z” value is in a formatted date string and adjusting that value will compensate for time difference. However, I still need some help to change the “2020-06-09T01:52:41Z” date string to regularly formatted date string, “Tue, Jun 9, 2020” in Tap Forms. Is there a calculation function that will accomplish that?
Thanks for the help Sam. I figured out what’s going on. Problem is, I overthink things sometimes and over look the simple solutions.
Turns out I was importing the date fields as text field types, instead of date field types. Once I corrected that, Tap Forms restored the proper UTC for each imported date field.
Doh…
Good to hear you got it resolved in the end :) And now you know even more about Tap Forms!
.
