Issues with Zapier and Dovetail Date Formatting Explained

Emi F.

Has anyone else had issues with Zapier->Dovetail and interpreting dates?

1.
I set up a zapier to extract a YYYY-MM-DD date from a slack message (specifically from the message text, not from the message timestamp. It's a written report)
2.
I send that output to the title of the Data/Note, and also to a date field
3.
It populates correctly (ie 2025-04-23) in the title BUT it read as 22 Apr 2025 in the date field.

In Dovetail itself, the date field interprets my text input just fine so IDK what got lost when it sent from Zapier

12 comments

Emi F.
·
·
However, if I just sent Dovetail a simple text input of YYYY-MM-DD to feed into that field, why would it change it?
Emi F.
·
·
Is there a recommended way to specify the date is PST then, if it's a UTC issue?
Pat B.
·
·
Are you able to try passing the original message timestamp into the date field in Zapier, rather than passing in the extracted YYYY-MM-DD format? The original timestamp should include the correct timezone info at the end. Then you can still pass your cleaner extracted date into the title of the data. Let me know if that works!
Emi F.
·
·
I'm not using the message timestamp because its not the date I need. I'm importing a written report of onsite visits to customers ie "sent at 2:45 today" Date of visit: 2025-04-18 I extract the YYYY-MM-DD from the body of the message text itself using Zapier formatter
Pat B.
·
·
Ohh, so Slack isn’t a trigger or action in the Zap itself?
Emi F.
·
·
It's a zap that triggers when I use a specific reaction on the message, which prompts the import
Pat B.
·
·
Ah ok, just to make sure I understand correctly. The message text itself has a date and time written in it, and this is different to the timestamp of the message itself?
Emi F.
·
·
Yep that’s correct
Pat B.
·
·
Got it. If you add a second date formatter and pass in the YYYY-MM-DD date, you’ll need to pick From Timezone: US/Pacific and To Timezone: UTC. Then it’ll return the same date in UTC timezone which is what gets passed through when imported to Dovetail. When you view the date field on the note in Dovetail after that, it’ll convert to your browsers current timezone (in this case PST, so it’ll show as the previous day). If you had a teammate in London viewing the same note, they would see it as the next day (exactly like what you see now in your note where the dates are different)
👀1
Emi F.
·
·
Aha let me try that. Thanks Pat for this very "in the weeds" tip
Emi F.
·
·
This has been working and I noticed within the last week or two it stopped working. Any changes on your guys's end that would affect this? It's reading as a day early again. Looks like it stopped working around May 16th
Pat B.
·
·
I’ll take a look into this with you! Might need a few links and screenshots, so let me try starting a new conversation directly with you that you should see within your workspace or through your email and we can chat there 😊