Need input for setting up date and timestamp fields in an international runtime
Posted 31 January 2012 - 08:42 AM
I built a runtime solution that'll be used internationally and am having trouble figuring out how to enable users to pick a date format they prefer. For example, here in the States we use the MM.DD.YYYY format whereas in Canada it's DD.MM.YYYY...and even some users want to incorporate ISO 8601 where dates or timestamps are presented as YYYY-MM-DD HH:MM (Z)).
There are about 40 different date fields in 11 different tables so I'm looking for a systemic way of doing this so when a user goes to the Main layout s/he selects a date format s/he likes all the date fields comform to that choice.
Any ideas? TIA for your help!
Posted 31 January 2012 - 08:49 AM
Posted 31 January 2012 - 03:25 PM
Mike(?), if we ever get a chance to meet in-person I want treat you to a fine dinner. Thanks again!
Lifelong FM Student
Posted 21 February 2014 - 03:49 PM
And his name is Michael. :-)