Use System Formats and the Evaluate Function - changes date back to wrong format

[truelifeajf]

I know date formats has been an ongoing complexity of FileMaker for years.... but here's a new problem (to me)...

 

----- The setup -----

File was built in Australia - using Australian formats.

 

Orders::event_date = date field, with 19/09/2014 (Australian Format) in it

 

Script on startup = Use System Formats [on]

 

 

----- Opening on a US System -----

When I open on a system using US formats, I see that:

 

Orders::event_date = 09/19/2014 (US Format). All good.

 

And:

 

Evaluate("Orders::event_date") = 09/19/2014 (US Format). All good.

 

 

----- BUT... The problem... -----

 

Evaluate(""we will arrive on " & Orders::event_date & ", at"")

 

results in:

 

we will arrive on 19/09/2014 at

 

Australian Format!

 

Why, when there's text in the Evaluate format does the date format switch back to Australian format?

[comment]

See:

http://fmforums.com/forum/topic/94354-determine-date-format/?p=431475

 

--

P.S. Your use of Evaluate() seems peculiar.

[truelifeajf]

Ah, so it's a known bug. That sucks.

 

So it's because (I assume) FileMaker Evaluates AS TEXT when there's something more than a date to evaluate.

 

I also did what I thought was a thorough search for an answer on here before posting. Ah well.

 

And yes my usage seems peculiar but that's because I've just simplified a far more complex calculation that was in play.

 

Thanks for your answer!