Jump to content

  •  

UPGRADE DEADLINE - SEPTEMBER 26, 2014!
FileMaker Inc. has a deadline for users of version 10,11, 12 as Individual box or volume licenses (with expired maintenance).
If you don't renew your maintenance and upgrade to FMP 13 you will no longer be eligible to upgrade, at the discount pricing.

Volume Licensing upgrade pricing for FileMaker Pro 13, FileMaker Pro 13 Advanced and FileMaker Server 13 will be discontinued.
Individual upgrade pricing for FileMaker Pro 13 and FileMaker Pro 13 Advanced will increase after September 26, 2014.
As of 27-September-2014, FileMaker 10 products will no longer be available for purchase or support.

http://help.filemaker.com/app/answers/detail/a_id/13865


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
  • 385 posts
  • FM Application:13 Advance
  • Platform:Cross Platform
  • Skill Level:Intermediate
  • Time Online: 1d 18h 54m 40s

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
  • 24,185 posts
  • Time Online: 328d 23h 39m 36s

Posted 31 January 2012 - 08:49 AM

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

#3 WF7A  Rich

WF7A
  • Members
  • 385 posts
  • FM Application:13 Advance
  • Platform:Cross Platform
  • Skill Level:Intermediate
  • Time Online: 1d 18h 54m 40s

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,786 posts
  • LocationOregon
  • FM Application:13 Advance
  • Platform:Mac OS X Mavericks
  • Time Online: 217d 13h 27m 1s

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