This content has been marked as final. Show 3 replies
Filemaker does allow you to display dates as MM-YYYY - but you must have a valid (full) date value in the field. It sounds like you have imported non-dates into a date field.
Thank you very much. So the data must be entered as 12/25/2007 and then you can format it to display what you like. I'm importing records from Access and will need to convert all these dates.
You might be able to pull up the values in Access in a query where you can format the dates as needed for an export (analyze with excel in the tools menu) into an excel file. That might be the quickest way to get a clean import.