Skip to main content

How to Fix the Date and Time Offset in Jotform

Written by Tominaga
Updated this week

📝 Overview

When using an “Appointment” field in Jotform, you may notice that the date and time retrieved in Yoom do not match your local time.

This guide explains why this happens and how to fix it automatically.


🔍 The Cause

This happens because Jotform saves appointment data "answer.date" using its internal server time zone “US Eastern Time” (American/New_York).

When Yoom retrieves this data, it reflects the US time zone.

⛏️ How to Fix

To correct the time, add an AI Operation “Generate Text” step after your Jotform trigger. This step will act as a time zone converter.

📍 Here’s a "Generate Text" prompt example for converting to JST timezone:

Date & time to convert:

##{{Date & time retrieved from Jotform}}

Conditions:

  • If the date and time fall within Daylight Saving Time, add 13 hours to the time.

  • If the date and time fall outside that period, it is Standard Time, so add 14 hours to the time.

Output format:

Return only the result in “YYYY-MM-DD hh:mm” format.

That’s it!

Your Jotform appointments will now be aligned with your local schedule. 🎉


📚 Related Guides

  • How to Configure Webhooks in Jotform and Retrieve the Latest Responses - View Guide Here

Search Keywords

Jotform, Date & time, Date, Time difference, timezone adjustment, JST, Daylight saving, AI correction, Time, Adjustment, Correction, AI

Did this answer your question?