1

Time discrepancies in calculations (Demo app)

Topic: Time discrepancies in calculations with timestamps, 'Date + Time', or 'Appointment' fields

Short description: 

If time calculations result in discrepancies of 1 hour or more, this is usually because the server hosting the current workspace does not use the same time zone as its system time as the time zone the user employs on their devices and systems.

The database shows how to resolve this issue, especially when working in the public cloud, where the server’s time zone cannot be changed for the user.

 

Search words

time calculation, time, rescheduled, incorrect time, wrong time, wrong hours, time shift, 'date + time', appointment, 1 hour, 2 hours, time zone

1 reply

null
    • Mel_Charles
    • yesterday
    • Reported - view

    For me as I only deal with UK and no appointments or time sensitive related issues. It is not a problem. However the example DB offered is well constructed and very useful to keep.

    So thank you for pointing out the potential problem !