Constructing valid date from 3 sets of numbers 1

[KingElvis]

I wish to convert 3 numbers (for example, 10, 5, 2004) to a date and then subtract that date from today's date.

I tried writing something like this

enteredDate = cInt(Request.Form("smonth")) & "/" & cInt(Request.Form("sday")) & "/" & cInt(Request.Form("syear"))
response.write date - enteredDate


However I get an error. Is my code for 'enteredDate' a valid date, or is it simply a string? If it is a string, then how do I construct it as a date?

 

[mbiro]

wrap it in a cdate() and use the dateadd function

 

[Tarwn]

Or use DateSerial and save yourself the 4 concatenations and conversion.

-T

 

[mbiro]

Didn't think of that, Tarwn. Much simpler.