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?

6 replies

null
    • Mconneen
    • 4 yrs ago
    • Reported - view

    @Peter, 

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

    • Post Hoc Limited
    • Peter_Amies
    • 4 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).

    • Mconneen
    • 4 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

    • Post Hoc Limited
    • Peter_Amies
    • 4 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?

    • Marc_Di_Francia
    • 4 yrs ago
    • Reported - view

    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

    • Alex_Mumm
    • 1 yr 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..

Content aside

  • 1 yr agoLast active
  • 6Replies
  • 1797Views
  • 1 Following