Skip to Content
0
Former Member
Apr 22, 2009 at 11:35 AM

Problem with an Excel data source, where dates are being treated as strings

24 Views

I am using two spreadsheets as data sources for a report. One spreadsheet has a lot of columns which contain date and time e.g. (07/10/2008 11:59). When I show the field type on the Field Explorer, some dates show as u201Cdate timeu201D and others are u201Cstring [255]u201D. When I u201Cbrowse datau201D on the dates showing as strings, I cannot see any data at all, even though the spreadsheet DOES contain dates.

I have tried reformatting the spreadsheet cells as dates and this makes no difference, I have tried using Excel 2003 and 2007 and this makes no difference either.

What is the problem? Why is there nothing showing in the u201Cbrowse datau201D