How to format a date in a calculation field

Followers

January 10, 201115 yr

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!

January 10, 201115 yr

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

HTH

Lee

January 10, 201115 yr

Author

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....

January 11, 201115 yr

Try =

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

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

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