Forum Discussion

ArchiveUser's avatar
ArchiveUser
Qrew Captain
9 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 ...
ArchiveUser's avatar
ArchiveUser
Qrew Captain
9 years ago
What I'm thinking I'll probably do as a temporary solution is create the timestamp in JS, capture the offset from the UTC time and store it in a separate field from the timestamp itself.  Then I'll create another formula field used to subtract the offset from the timestamp, and that'll be the value I use in the notification.