Time Zones and Storing Dates Correctly
Dates and times cause more subtle bugs than almost anything else in software. A booking that shows the wrong hour, or a report that double-counts a day, usually traces back to careless handling of time zones.
The fix is a simple, disciplined rule that we apply across every system we build, so your data stays accurate wherever your users are in the world.
The Golden Rule
We store every date and time in a single universal standard (UTC) on the server, and only convert it to the user's local time when displaying it. This keeps the stored data unambiguous and easy to compare.
- One consistent reference for all stored times.
- Correct display for users in any time zone.
- No confusion across daylight-saving changes.
Why It Matters to You
If you operate across regions, or simply want reports that add up, getting this right is essential. It is far cheaper to do correctly from the start than to untangle later.
If you need a hand with any of this, your Progressive Robot delivery team is ready to help. Raise a ticket from the Support area of your client portal or speak to your account manager and we will guide you through the next steps.