Date Formats Showing ? in FMP 11
I am trying to adjust my date format to YYYY-MM-DD.
I have gone into the field options and selected "use saved."
I have gone into the layout inspector and changed the date options to reflect my desire (YYYY/MM/DD). Inputting a new date returns an error about needing to be in a MM/DD/YYYY form.
Choosing "as entered" in the layout inspector, the entire field then becomes " ? " although the data is preserved. It also does not permit sorting according to that field.
Leaving the field as "text" allows for appropriate sorting according to date.
Does any one have any idea on how to fix this issue?