troubleshooting Question

Excel Date/Time field exports as String (Computer-Specific Issue)

Avatar of rporter45
rporter45 asked on
Crystal ReportsMicrosoft ExcelMicrosoft Office
5 Comments1 Solution72 ViewsLast Modified:
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 -

Our community of experts have been thoroughly vetted for their expertise and industry experience.

Join our community to see this answer!
Unlock 1 Answer and 5 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 5 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros