I have a custom date field that formats dates to 'Month Year'. When I export records to other colleagues that have an identical runtime of my database and they import the records, that date field displays a'?'. I think the issue is that when I export records the date field exports the custom format 'Month Year' and not DD/MM/YYYY which is what is actually entered into the date field in the first place. I would like to keep the date field within my database and the runtimes as the same format. I could get round the problem by changing the date field to a text field but don't think this to be good practice. Are there any other options? I don't know why FM exports the custom date format which then confuses the runtimes instead of exporting DD/MM/YYYY which is how the date is originally entered.

You didn't say what format you are using for the export. In any case, make sure the option 'Apply current layout's data formatting...' is NOT selected.

Many thanks Comment, it was indeed the 'Apply current layout's data formatting...' check box that was ticked.