Changing the date format
I have a date field that I need changed: from 1/5/2010 to The 5th Day of January, 2010.
I am using FMP 10 Advanced.
Go to correct layout, enter layout mode.
Highlight field to edit format. (assuming it IS a date field)
Choose Format Menu > Date
Or right click field to choose "Date Format"
You can have two copies of a date field on one layout, each with a different Date Format.
The problem comes with 1ST, 2ND, 3RD Day of Month, Year.
Retrieving data ...