The Prompt BakeryTemplates and prompts

Fix · Pages, phones and Arabic

Dates and times are off by hours (Kuwait time)

Kuwait and Gulf

What you may see

  • An order shows 3 hours earlier or the wrong day
  • A scheduled job runs at the wrong hour

Most likely cause

Servers and databases store times in UTC, but people expect Kuwait time (UTC+3, no daylight saving).

Check first (about two minutes)

  1. Compare the time in the database (UTC) with your clock.

The fix prompt

What you type here never leaves your browser. The search runs on this page, and nothing is sent to a server or to an AI.

Kept only in this browser, on this device. Keys and passwords are removed before anything is saved.

Prompt language

Paste it into Claude, ChatGPT, Gemini or Cursor, then follow what it says.

After you tried it, did it work?

Steps

  1. Find where times are stored and where they are shown.
  2. Store times as UTC timestamps; format for display with the Asia/Kuwait time zone explicitly (not the server's zone).
  3. For "today" or "this month" reports, compute the day boundaries in Kuwait time.
  4. For scheduled jobs, convert Kuwait hours to UTC (subtract 3).

Do not do this

  • Do not store local-time strings without a zone.
  • Do not change stored times in old data.

Related

Try another entry

How can we help?

What do you need?
Your email, so we can reply (optional)Only enter your own email. We reply there.