Search the Community
Showing results for tags 'Type Missmatch'.
[*] Hi I have a work around for this one but for other reasons I want to work with numeric dates e.g. 01/02/2010 rather than string dates e.g. 1 February 2010. IF I use the Visual basic adate = CDate(#1/2/2010#) all works perfectly and adate would have the value 01/02/2010 in date format. Here is where the problem starts. The date is captured from an ASP Form using form dropdowns for day and month so the code looks like this Dim xday, xmonth, xyear, adate xday = Request.Form("xday") xmonth = Request.Form("xmonth") xyear = Request.Form("xyear") adate = CDate("#" & aday & "/"