Export/Import Custom Date Field

[adyf]

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.

[comment]

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.

[adyf]

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