Date/Time Best Practices

1
Is there a suggested way to handle all the date/time attributes in your project? What I mean more in specific relates to a few things...should we always localize all dates if it is possible that our users will be in different time zones? How would then be the best way to compare date/time variables if the DB stores them in UTC?
asked
2 answers
5

Hi Brian, At some point I created a slidedeck explaining some of the things to consider when working with dateTime fields. Feel free to take a look at these slides. Be aware these examples are from Mx5.5 and DateTime has improved significantly for the better so some examples in this file might no longer apply to Mx6.
However the important aspects such as when to use localization and what to remember still applies in Mx6

https://www.dropbox.com/s/0z6x4zuodndpnv0/Workshop-DateTime.pdf?dl=0

answered
0

Additionally to Japser's link to the slide deck see https://world.mendix.com/display/refguide5/DateTime+handling+FAQ in the documentation, it explains a lot.

answered