
today() function returns yesterday's date on web app
Using the today() function to insert today's date, instead returns yesterday's date when using the web app. However, it returns the correct date when using the iOS app so the web app is obviously getting it's date from a different source. Can't it just use the system date?
-
So I tried it again this morning (new day) and the web version is once again inserting yesterday's date. When this happened yesterday, it seemed to start inserting the correct date around 4 pm Pacific Standard Time (USA) when it finally recognized the new day but that's 16 hours late. My PC says the correct time, where else could it be coming from?
-
The code is very, very simple. It is used on "Trigger after update" for a Single Choice field named "StockChecked" so that when a user checks the stock level and chooses "Reorder" or "OK", this code fires;
StockChecked := today();
DateTimeTest := now()The StockChecked field is malfunctioning, while the DateTimeTest works perfectly.