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

rporter45
rporter45 used Ask the Experts™
on
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 -
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Rob HensonFinance Analyst

Commented:
Check the local region settings for each computer in the Control Panel.

If the date is for example 12/14/2019 and the region is set to US the it would recognise it as a date (14 December) but if set to UK it would not recognise it as a date as it would try and read it as the 12th day of month 14
Mike McCrackenSenior Consultant
Most Valuable Expert 2011
Top Expert 2013

Commented:
What version of Crystal?

Author

Commented:
It's 11.5 - but works fine on my machine and someone else's machine - they are using office 2010

thanks -
Hi there - it looks like this is an issue with excel and how the data is exporting from the database - thanks very much for responding.

Author

Commented:
Issue between older versions of excel being exported from the database and using a new version on the individual's machine.

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial