string to date

[is1ma1il]

Hi,

I am trying to do a microsoft query to pull data from a csv.
And in field date is as a string. but once the microsoft query has run i need the date field to be a date field, so i can sort it by date.

Can it be done in the query?

 

[xlbo]

In vba, you can use:

Dim mVal As Long
For Each c In Range("DateRange&quot
mVal = DateValue(c.Text)
c.NumberFormat = "dd/mm/yy"
c.Value = Format(mVal, "dd/mm/yy&quot
Next

After the query has run - this should convert all your textdates to actual dates Rgds
~Geoff~