Jump to content

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


This topic is 2911 days old. Please don't post here. Open a new topic instead.

Recommended Posts

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?
Link to comment
Share on other sites

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! :)

Link to comment
Share on other sites

This topic is 2911 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
 Share

×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.