Incorrect Date format

[mse]

I have a JobStatus (Text, Pop-up list) and a StartDate (Text, Auto-Enter, Calculation) fields, so that e.g.

StartDate=Case(JobStatus = "Running"; Status(CurrentDate); "")

On a test layout everything is OK, but then I implant it in a FileMaker Solution Framework (by Matt Petrowsky) the StartDate calculation returns

3/12/2003 in place of 12/03/2003

irrespecive of "Date Format" settings and "Use System Format" checked.

Have someone an idea ?

[RussBaker]

Why do you want your Start Date as a text field? This is going to give you big problems with sorting etc later on. As a date field the auto enter calc would be:

Case(Job Status="Running",Status(CurrentDate),TextToDate(""))

to give you a blank date instead of a "?".

BUT - doing it the way you have proposed will not cause the date to be updated if you change the job status, in which case you may need to make Start Date a calc field - with the same forumla.

If this doesn't fix your date format problems, then you will need to make a clone of your modified Petrowsky file, and then reimport your data into the clone - use matching field names on import.

[mse]

I've tried almost anything:

Case(JobStatus="Running", Status(CurrentDate), "") - not giving a "?" actually,

Case(JobStatus="Running", Status(CurrentDate), TextToDate(""))

and even

Case(JobStatus="Running", Day(Status(CurrentDate))&"/"&Right(

[Lee Smith]

Sorry for coming in late here. But if this is a matter of wanting to swicth the file from US style to Euro style, I think you have to [color:"red"] Save a Copy (clone) without records [color:"red"] (No Records) and then when it opens the and asks you about System, it will actually change it to your system

HTH

Lee

[mse]

That's what I successfully achieved following the Russ' advice.

The questions are :

1. why all the settings (see my posters above) did not work ?

2. how sould I proceed with the other files of my DB ?

[Lee Smith]

From what I understand of this process, the settings should have reset to your system settings?

What other files are you referring to. Were these part of JMO's original files too? If so, you probably need to start with a empty copy (clone) of all of the files at the same time, as something is preventing this from changing from the US.

Not sure if this is the case, but if it persists, maybe someone like Dj can help you, as he had to covert his "Calendar" to US for me.

So, if these suggestion still don't work, maybe write him a note and get his advice or assistance.

[color:"red"] BTW, you can't be the only one on this list to have had to change these files?:

Lee

[mse]

Fortunately my db is still not much populated