0

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?

6replies Oldest first
  • Oldest first
  • Newest first
  • Active threads
  • Popular
    • Mconneen
    • Mconneen
    • 3 yrs ago
    • Reported - view

    @Peter, 

    What platform are you on?   Works fine for me via Mac App and Web App.. 

    Like
    • Peter Amies
    • Post Hoc Limited
    • Peter_Amies
    • 3 yrs ago
    • Reported - view

    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).

    Like
    • Mconneen
    • Mconneen
    • 3 yrs ago
    • Reported - view

    @Peter.. 

    Hmmm... Webapp working fine for me.. 

    webApp

    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... 

    now

    Like
    • Peter Amies
    • Post Hoc Limited
    • Peter_Amies
    • 3 yrs ago
    • Reported - view

    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?

    Like
  • 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.

    IphoneNinoxdate

    Like
    • Alex Mumm
    • Alex_Mumm
    • 11 mths ago
    • Reported - view

    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..

    Like
Like Follow
  • 11 mths agoLast active
  • 6Replies
  • 1769Views
  • 1 Following