Now you see that a date has a time as well, it is just not visible in the UI of Ninox. When you pick a date in a Date field it defaults to 12:00 AM, LOCAL TIME.
Notice the local time. The Server might be in a different time zone than you. If you
use the “do as server” running the today() function, you will get your today minus the time difference between you and the server. When that time difference gets added, depending on what part of the Globe you are on, you will see the previous or next day as result. It also depends on what time you run this code.
Ninox is working on converting the DATE field into a static date field so it won’t include the time (and time zone) data. That means if there are 2 different users using the same program and the users are in a different time zone they still will see the same date in the field.
How can you fix this issue for now? You can take away the time difference between you and the Server.