Date Format Changes in Excel

[Jhoe_(Guest)]

Good morning,____I would like to ask what could be the possible solution to a date format that converts to special characters when exported to Excel. ____example:__date format in R&R (mm/dd/yy): 02/12/06____when I export the file to Excel, date becomes: TB_____All other data exports successfully to Excel the way they should be except the dates.____Please help!____Thank you very much.

[kfleming]

In your report, create a DTOC() field in place of the actual date field on the layout. This will generate date output that will correctly recognized in Excel.____Kathleen__R&R Support

[Jhoe_(Guest)]

Thank you very much! That worked for my report.____Best regards.