Jump to content

  •  

Photo

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


  • Please log in to reply
3 replies to this topic

#1 WF7A  Rich

WF7A
  • Members
  • 380 posts
  • FM Application:13 Advance
  • Platform:Cross Platform
  • Skill Level:Intermediate
  • Time Online: 1d 17h 32m 32s

Posted 31 January 2012 - 08:42 AM

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!
  • 0

#2 comment  consultant

comment
  • Members
  • 23,974 posts
  • Time Online: 319d 19h 12m 10s

Posted 31 January 2012 - 08:49 AM

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

#3 WF7A  Rich

WF7A
  • Members
  • 380 posts
  • FM Application:13 Advance
  • Platform:Cross Platform
  • Skill Level:Intermediate
  • Time Online: 1d 17h 32m 32s

Posted 31 January 2012 - 03:25 PM

*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!
  • 0

#4 LaRetta   Lifelong FM Student

LaRetta
  • Members
  • 9,680 posts
  • LocationOregon
  • FM Application:13 Advance
  • Platform:Mac OS X Mavericks
  • Time Online: 206d 17h 27m 17s

Posted 21 February 2014 - 03:49 PM

And his name is Michael.  :-)


  • 0
Each assumption is an educated guess, a likely condition or event, presumed known and true in the absence of absolute certainty.




FMForum Advertisers