convert string to datevalue

[jasontektips]

Hi,

Just a quick one ... can any kind soul help to provide the code to convert string to date, please..

I have the following string:
sDay="03", sMonth="07", sYear ="2000"
I want to convert this to a datevalue.
Please note that I want 3rd July 2000, and not 7th March 2000.

Many many thanks.
JAson

 

[foxbox]

http://www.devguru.com/Technologies/vbscript/quickref/dateserial.html

 

[foxbox]

oke, because you start with char fields, this one:

http://www.devguru.com/Technologies/vbscript/quickref/datevalue.html