This is the error message I get when trying to view a calendar built from ASP and MSSQL as the database
Microsoft OLE DB Provider for SQL Server error '80040e07'
The conversion of a char data type to a datetime data type resulted in an out-of-range datetime value.
Here is my code : It works with ACCESS but with MSSQL I get thee problem.
dateSelect = Cdate(dayCounter & "/" & thisMonth & "/" & thisYear)
Set RSDATE = Server.CreateObject("ADODB.Recordset")
SQLDATE = "SELECT * FROM tbl_calendar_Events WHERE (Day(Date) = Day('"&dateSelect&"')) AND (Month(Date) = Month('"&dateSelect&"')) AND (Year(Date) = Year('"&dateSelect&"'))"
RSDATE.Open SQLDATE, Conn, 1, 3
If NOT (RSDATE.BOF AND RSDATE.EOF) Then
dateBack = "#DAE3F0"
dateBack = "#F0F0F0"
set RSDATE = nothing
Please could I get a hand at sorting this.
i have tried dateSelect= Cdate(dayCounter & "/" & thisMonth & "/" & thisYear) but no joy.