I have encountered a bug that completey breaks using value lists with dates in FMP12.
I have tested this on migrated FP7 and newly created FMP12 databases on Mac OS Lion and Windows 7.
Steps to recreate
Install FMP12 on Mac OS 10.7.3 or Windows 7 set to UK system format (DD/MM/YYYY).
Create two new fields: -
DateAsText = Calculation, result=Text, Formula: date (gives us the date in UK format, but is treated as text, not a date)
DateAsNumber = Calculation, result=Number, Formula: date (will return the day number since the year 0000 - we use this to sort the records in the right order)
Now edit your value list which references the date field and change it to reference the DateAsText field, and add secondary values from DateAsNumber, sort by second field, do NOT hide first field.
Now your drop down will show: -
Its fugly but it works and will just drop the actual date (in the correct format) in to the field.
FMP12v2 where are you? Any eta?