Forum Discussion

ArchiveUser's avatar
ArchiveUser
Qrew Captain
8 years ago

Timestamp stored via API being returned as UTC in notification email

I have a notification that triggers when a timestamp field is updated via an API EditRecord call.  The timestamp is generated by JavaScript and is stored in QB in UTC time.  This isn't a problem when ...
MCFNeil's avatar
MCFNeil
Qrew Captain
8 years ago
If your clients are in different time zones, I'd recommend identifying the different times zones (via a table) and have the 'adjustment' from UTC be a numeric value, then your time can be a formula of the difference.  Then no matter where they are, it should adjust.

Not perfect, but an idea.
  • ArchiveUser's avatar
    ArchiveUser
    Qrew Captain
    8 years ago
    Thanks Matthew!  I ended up doing something very similar, and it works.  Appreciate the feedback.