Convert a String to Date format 1

[icarus5000]

I'm trying to convert a string in the format "2002-03-04 00:00:00.00" to a Date format.

I have tried

CDate(val(Mid({Query.Edate},6,2)), val(Mid({Query.Edate},9,2)), val(left({Query.Edate},4)))

but get the error "A month number must be between 1 and 12"

Thanks in advance.

 

[lbass]

Try this:

CDate(val(left({Query.Edate},4)),val(Mid({Query.Edate},6,2)), val(Mid({Query.Edate},9,2)))

-LB

 

[icarus5000]

Nice one!

Thank you.

 

[Reebo99]

Easier to just use :

DTStoDateTime("2002-03-04 00:00:00.00&quot



Reebo
Scotland (Sunny with a Smile)