today() function giving yesterday's date
Today I've been having two big issues with date functions in Ninox:
1 - If I use the today() function, it returns yesterday's date.
2 - I am trying to compare two dates within an if statement. They are the same date (to the point where if I use the number(date) function, they show the same exact value), but the comparison comes back false.
Are there major bugs with the date functions? Are these issues common?
What platform are you on? Works fine for me via Mac App and Web App..
Found a previous post suggesting it that it may be related to server side settings (maybe even down to the server clock being incorrect).
Hmmm... Webapp working fine for me..
I should remember this.. but I do not.. Pretty sure it is using browser / local settings for the date / time display .. but it stores them in unix / epoch...
Using the console is working for me, too. BUT, in my table, I have a "Trigger on Create" script that is doing:
'Record Added' := today()
This is what fails for me. And if these triggers are getting run on the server, maybe they're using server time, whereas the console uses client browser locale?
So I have the same sort of trouble with dates in browsers.
I Made a very simple base : one table, one field (date type), one record !
See how it is displayed in different browsers and the Iphone app.
I'm having the same problem, but with the Date function. Any numbers I enter into that function return the previous day. For example, date(2022, 3, 6) gives me March 5th. I'm using the web app and Android app..
- 1 yr agoLast active