For example you decide to change table view by grouping Date column. This will not change Date value, but it is still a big problem because it does not equals to same Dates with different timestamp. Because every Date value in the database has 00:00 Time value hidden as soon as device Timezone setting changes backwards (and usually everybody have it to automatically change, because otherwise time stops being accurate after a while) all those Dates shifts 1 day backwards with hidden Time value of 23:00.ĥ) Problem persists even more when new records are created while being in a different Timezone because those records will have 00:00 hidden Time value that will turn to anything like 02:00 or 04:00 after Timezone will return to original. Ĥ) Although for Time fields this is convenient, but for Date fields this brings a major problem. Although time is different, but it shows at what moment it was created for both of team members. For example if a record was created in a country UTC+2 at 15:00 then another team member living in country UTC+1 will see it as 14:00. This is very important because it allows to work internationally. In other words Date fields are the same as Date / Time with the only difference that it leaves out Time value and uses 00:00 by default.ģ) Unix timestamp value is affected by Timezone settings in the device. So it is not 100% accurate where in Ninox manuals it says that Date fields are of Date type. Unix format value in programming is called timestamp value and falls into Datetime type. Every time you put a Date in a Date field it stores 00:00 time next to it without user knowing about it. You can refer to your your Date field as an alternative.Ģ) Storing Date value in Unix is the same as to store Date and Time value. Ninox and iOS versions up to date.ġ) Ninox date fields store dates in Unix format you can check that by making a formula field and putting number(today()) or format(today(), "x") where today() is a function that returns Date value. I have checked and experemented on iPhone and iPad using both Ninox App and Ninox cloud through browser. I would like to share my experience with other users as well as ask for improvement features from Ninox support in upcoming updates regarding Date fields that are affected by timezone setting in the device.
0 Comments
Leave a Reply. |