How to format a date in a calculation field

[adamworking]

Hi all

I have a calculation field that includes a date field within it:

& INV::EventDate &

However, how can I format this in the calculation field so that it display as DD-MM-YY rather than the default american format of MM/DD/YY

Many thanks for your help in advance!

[Lee Smith]

The date format is determined by the Opearting System settings, and can not be changed within FileMaker.

HTH

Lee

[adamworking]

Hi Lee

Thanks for your response. Is there anyway that in my table, I can create three new fields, and each field then grabs part of the date. So one part grabs the date, one the month, one the year?

Alternatively, I guess I could just change the field from a date field to a text field....

[comment]

Try =

SerialIncrement ( "00" ; Day ( INV::EventDate ) ) &

SerialIncrement ( "/00" ; Month ( INV::EventDate ) ) &

SerialIncrement ( "/00" ; Right ( Year ( INV::EventDate ) ; 2 ) )