0

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?

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

    Hmm.. Works as designed for me.. 

    today

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

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

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

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

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

    The servers are in DE.. which I believe is GMT+2 ..  I am not sure if JavaScript or the server is resolving "now".  I defer to the Ninox folks. 

    Like
Like Follow
  • 3 yrs agoLast active
  • 6Replies
  • 2886Views