Sign in to follow this  
Followers 0

Need input for setting up date and timestamp fields in an international runtime

4 posts in this topic

Posted

Howdy, all:

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!

Share this post


Link to post
Share on other sites

Posted

File > File Options… > Text > Data Entry: • Always use current system settings

1 person likes this

Share this post


Link to post
Share on other sites

Posted

*slaps forehead* It's a good thing my head's attached to my shoulders or I'd forget that, too.

Mike(?), if we ever get a chance to meet in-person I want treat you to a fine dinner. Thanks again!

Share this post


Link to post
Share on other sites

Posted

And his name is Michael.  :-)

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!


Register a new account

Sign in

Already have an account? Sign in here.


Sign In Now
Sign in to follow this  
Followers 0