Bug in DateTime field?

I cannot figure out why I got the same integer (19334) for december 8 and for december 7. I was thinking that this integer represent the day. Is there anybody that can explain this behavior?

Here a printscreen with one of my test:

The final goal is to calculate the number of days since today.
Thanks a lot!

More tests

Hi @Amber ,

This may not answer exactly what you are looking for.

But try look at Komun template in this forum, it explains about timezone.

You can use ROUND() to get more consistent value.

Search for Karimoo post in this forum too, this issue has been solved like 2 years ago.

1 Like

This topic was automatically closed 10 days after the last reply. New replies are no longer allowed.