Date Field Won't Export as Confingured

Applications Grid / Reports
, , ,
#1
  1. 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.

IDEAS???

  1. 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

#2

Scriptcase, is this a bug?

#3

Yes, is this a bug?