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,516 posts
  • Time Online: 299d 16h 8m 57s

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,521 posts
  • LocationOregon
  • FM Application:13 Advance
  • Platform:Cross Platform
  • Time Online: 167d 5h 22m 41s

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