Hi there, I have an excel file connected to a crystal report. This file has a date/time field called gift date. When the data is extracted on one machine, the field is recognized as date/time, as it should be. When the data is extracted and merged with the report on another machine it is a string field. The exported file is an Excel 97-2003 (options are limited in this older software) - do you have any ideas on how to work around this?
thank you -