- I have a Grid with a couple of Date Field Displays and all display as configured in the ddmmyyyy format.
If the user tries to Export to a XLS, CSV or XML, the date in only one column appears in the mmyyyy no matter what format is configured but Exporting to a DOC appears in the ddmmyyyy format as required.
I have tried many variations of the “Values Format” under the Fields attributes and at present have it set for Regional Settings = “Yes” and Display = ddmmyyyy.
- I would really like to have the date exported to XLS/XLSX as a true date rather than text. Is this possible?
Thanks in Advance - Ken