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
  • 374 posts
  • FM Application:12 Advance
  • Platform:Cross Platform
  • Skill Level:Intermediate
  • Time Online: 1d 15h 7m 4s

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,500 posts
  • Time Online: 299d 9h 58m 1s

Posted 31 January 2012 - 08:49 AM

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

#3 WF7A  Rich

WF7A
  • Members
  • 374 posts
  • FM Application:12 Advance
  • Platform:Cross Platform
  • Skill Level:Intermediate
  • Time Online: 1d 15h 7m 4s

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,515 posts
  • LocationOregon
  • FM Application:13 Advance
  • Platform:Cross Platform
  • Time Online: 166d 10h 10m 53s

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