Hello everyone,
I'm currently building a workflow where customers submit information through a web form and the data is later processed through automation rules and notifications.
One challenge I've encountered is handling date- and time-sensitive inputs consistently across different user locations and timezones.
For example, some external tools rely heavily on an exact date, time, and location to generate results. During testing, I noticed that even small timezone differences can lead to different outputs being generated, which makes me concerned about how those values should be stored and processed inside Freshworks workflows.
I've been testing scenarios using tools such as:
because they make date/time discrepancies easier to identify during validation.
My questions are:
- Do you recommend storing all incoming values in UTC before triggering automations?
- How do you handle daylight-saving changes for workflows that may run days or weeks later?
- Have you experienced inconsistencies between user-submitted local time and workflow execution time?
- Is there a best practice for preserving the original user-entered datetime throughout an automated workflow?
I'm looking for recommendations from anyone who has implemented timezone-sensitive automations or integrations within Freshworks.
Thanks in advance for your insights.
