Ninox Cloud date bug?

Ninox Profile

When in Table mode on Ninox Cloud and in a Date field, and I copy a date from one record to another record (e.g., "2019-11-30") in the same Date field, and paste the value, I get instead "2019-11-29". It is subtracting one day from the copied date. The same thing happens to many (but not all) dates when I'm importing into the same Date field. This is not good for date-sensitive records. Can this be fixed, or am I doing something wrong?

Ninox Profile

As any Date will internaly be stored as a time stamp you should always consider copying like this:

–––
'myNewDate' := date(year('MyOriginalDate'), month('MyOriginalDate'), day('MyOriginalDate'))
–––

Birger

Reply