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?
Hmm.. Works as designed for me..
Yeah I’m not sure what was going on. It started working around 4 pm PST. Maybe it was just a temporary glitch. I’ll try again tomorrow morning and see if it does it.
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?
OK I am confused now. The field that is malfunctioning is a "Date" type field, so I decided to try to test a "Date / Time" field, and that works just fine! It displays the current date and time just as expected, yet the "Date" field still updates to yesterday's date...
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.
- 4 yrs agoLast active