US Date Format not changable?

Support, Tips and Tricks for Proof Group's fmSpark "merge anything" utility for FileMaker Pro.
Posts: 125
Joined: Tue Jul 15, 2008 12:41 am
Location: Perth Western Australia
PostPosted: Tue Jul 15, 2008 8:30 pm
Hi John

Even though I have change all files to use the current system settings for the date format before I uploaded them to the server, I still have the US date format when I create a new letter (ie. the window is called Untitled 7/16/2008).

But when I add a date with the Date Symbol or with the Current Date menu, it is actually correctly formated with 16/07/2008.

I checked all the scripts and fields, but they all use the Get (Current Date) function. It seems a bit strange?

Have you got any suggestions how to fix this?


SeedCode Staff
SeedCode Staff
Posts: 2760
Joined: Thu Nov 20, 2003 11:01 am
PostPosted: Wed Jul 16, 2008 12:44 pm
Sure thing. You can change the way dates are handled in two places:

First, in the text of letter, emails, and labels you can use the Functions in fmSpark to format dates in any manner you need to. When composing text click "Merge Field" in the fmSpark header and use the field at the top of the list to choose "Functions". You'll see our date functions there and you an format the date any way you wish. See this page for more info: ... /Functions

Second, when it comes to the window name, select "Settings" from the fmSpark menu and then click the "Developer" icon. Select the "Naming Formats" tab and you'll see that these names are just FileMaker calcs: change the calc as you see fit, perhaps to this:

"Untitled" & " " & Let ( n = Get ( CurrentDate ) ; Day ( n ) & "/" & Month ( n ) & "/" & Year ( n ) )

Hope that helps.
John Sindelar

Return to fmSpark

Who is online

Users browsing this forum: No registered users and 2 guests

Follow us: