We help IT Professionals succeed at work.

Excel Dates issue

Murray Brown
Murray Brown asked
on
111 Views
Last Modified: 2014-08-15
Hi. I have a list of 800 dates in Excel that I am trying to load to a database. The problem
is that most dates are not recognized as dates using the "IsDate" function unless
I manually type the date like the first one in the list. How can I convert all these dates
so my code recognizes them as dates?

28 September 2010
17/05/2010
01/09/2010
17/11/2010
20/07/2009
Comment
Watch Question

CERTIFIED EXPERT
Top Expert 2016
Commented:
This problem has been solved!
(Unlock this solution with a 7-day Free Trial)
UNLOCK SOLUTION
Cost Accountant
CERTIFIED EXPERT
Top Expert 2012
Commented:
This problem has been solved!
(Unlock this solution with a 7-day Free Trial)
UNLOCK SOLUTION
Rob HensonFinance Analyst
CERTIFIED EXPERT
Commented:
This problem has been solved!
(Unlock this solution with a 7-day Free Trial)
UNLOCK SOLUTION
Murray BrownASP.net/VBA/VSTO Developer

Author

Commented:
Thank you all for the help
SteveCost Accountant
CERTIFIED EXPERT
Top Expert 2012

Commented:
rob, my suggestion wasn't to get to the full date, but to a date which tends to be accepted on uploads.
The '234' date format is not effected by region and seems to work on almost any upload, being recognised as a date.
I tend to use it in most up-down transfers.
(but yes, 244 is just as valid, but takes up unnecessary space)