date format in calc field

[EllenG]

I have system formats turned on so that the date fields will be displayed correctly for my international clients. However, if I use a date field in a text calculation field, the format reverts to mm/dd/yyyy.

Example:

The Herd::DOB field for an animal in the database is 11/28/2008. This displays correctly in US format as 11/28/2008 and in European format as 28/11/2008.

I have a calc field = ("DOB: " & Herd::DOB) to display as 1 field

Regardless of the date format in use, this will display as

"DOB: 11/28/2008"

I tried GetAsText(Herd::DOB) and GetAsDate(Herd::DOB) in the calc field, but get the same results.

Is there a way to keep the system date format in a calculated field??

Thanks.

[Peter (duksis3)]

Yes.

instead of date=11/28/2008, use calc: [Day(11/28/2008)$Month(11/28/2008)$Year(11/28/2008)]

in combination you need.

[Lee Smith]

FileMaker only recognizes dates that match the Operations System's setting. i.e. you can not have a date that is Military (European) interact with a US date. You have to convert the non system date format.

There are several Threads on how to convert the date of one to the the other.

Assuming your system is US format, and that the other one is European, you would need to convert in order to have the dates interact. i.e.to change ddmmyyyy to mmddyyyy

NewDateField (calc, date result) =

Let([

Parts=Substitute(DateField;"/";" ");

Month=LeftWords(Parts;1);

Day=MiddleWords(Parts;2;1);

Year=RightWords(Parts;1)];

Day &"/"& Month &"/"& Year)

HTH

Lee