Have a list view screen with customers with a date of birth field. Is there a way to sort the list so that it shows all the january dates in order, then february, and so forth?
This custom function should do it for you.
FileMaker Custom Function:SortList ( ValueList ; Sort ; Type )
Add a calculation field to sort, as number
Month ( dob ) * 100 + Day ( dob )
Or calculate the birthday this year as Date ( Month ( dob ) ; Day ( dob ) ; Year ( Get ( CurrentDate ) ) )
Retrieving data ...