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?
-
@Peter,
What platform are you on? Works fine for me via Mac App and Web App..
-
Ninox Cloud.
Found a previous post suggesting it that it may be related to server side settings (maybe even down to the server clock being incorrect).
-
@Peter..
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.
Don't understand.
-
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..
