Dates are stored as an integer recording the number of days from the date shown to 12/31/0000. The data format you specify in the Inspector only controls how this integer is displayed as a date it does not change the value of that integer. In terms of your own work with this date from within FIleMaker, that format specification should be all you need.
It would appear that the key issue is getting this data exported as text in the desired format. When exporting records, there's an option to "apply current layout's data formatting". Have you tried using this option?
If all else fails, you can set up a calculation field that returns text that converts your date into the proper format for export and then you export that calculation field instead of the date field:
Year ( YourDateFIeld ) & "-" & Right ( "0" & Month ( YourDateField ) ; 2 ) & "-" & Right ( "0" & Day ( YourDateField ) )
That worked Great! Thank you!!!
I did modify it a little bit and fixed a minor mistake at the end, where it expected 2 digits for the Day. I ended up putting it into a script instead, but this is what I finally ended up with. Thanks again.Let ([ x = STARS Cleanup Template::Entry Date ] ;Year ( x ) & "-" & Right ( "0" & Month ( x ) ; 2 ) & "-" & Right ( "0" & Day ( x ) ; 2 ))