Jump to content
Sign in to follow this  
WF7A

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

Recommended Posts

WF7A    1

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
comment    1,391

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

  • Like 1

Share this post


Link to post
Share on other sites
WF7A    1

*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
LaRetta    481

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  

×

Important Information

By using this site, you agree to our Terms of Use.