I’ve checked these datetime values using the Google Sheets Cell Edit History which is leading me to believe there may be a misconfigured bot server or server cluster out there with a different server time.
I have a workflow that has been working fine for the past 30 days or so. The user gets a datestamped record to edit. After going through a number of edits, the user finally submits a form with a ‘signoff’ datetime value. The ‘signoff’ value is always going to be greater than the datestamp of when the record was created. The ‘signoff’ triggers a bot workflow that performs a number of tasks with one of the final tasks being to add another datetime value which represents when the record was completed.
So I have an initialisation datetime, a signoff datetime and server side calculated datetime. All are set using NOW()
On the 23rd May 2024 after 7pm (UK Time) a bot returned a completed time that was 1 hour BEFORE the record was initialised. The Google Sheets Cell Edit History correctly showed that the value generated by the bot had been inserted at 20:36 in the evening whereas the value inserted into that cell by the bot was 19:36:11 (I am just showing the time component here as both the dates were correct). So a discrepancy of 1 hour. This also happened with 4 other rows (total 5) that were processed at that time.
I have 60 previous rows that all have the correct date time values, however, all the previous bot runs took place BEFORE 7PM UK time. Perhaps a different cluster of servers were active at this time?
To save a lot of questions, my users do not access apps using mobile devices so device time is not in question here. The Google Sheets Cell Edit History for the record creation and the signoff both show the correct datetime. Only the bot time was off by an hour.
Can somebody investigate whether it is possible for a server misconfiguration to have happened or guide me on what else could possibly be wrong from my perspective?
