Exporting Dates to Excel

[Eddie_Marshall]

I am exporting to Excel using Version 8 of R&R. My data contains date fields, some of which are blank. When I export these blank dates to Excel, it interprets them as 00/01/1900 (UK format). Does anyone have a workaround to ensure that these blank dates are actually shown as blank in Excel.____Thanks.____Eddie

[kfleming]

You could use IIF() based DTOC() fields on the layout in place of the actual date fields and return "" in the case of error/blank dates.__Kathleen__R&R Support