Hi,
I get this error message
The conversion of char data type to smalldatetime data type resulted in an out-of-range smalldatetime value.
when try to insert the code below
theMonth = "dbo.tbl_banners" & Month(Today())
MM_editTable = "dbo.tbl_banners" & Month(Today())
MM_editTable = "insert into " & MM_editTable & " (agencyID,month) VALUES (" & Request("agencyID") & ",'" & Today() & "')"
can anyone tell me how to get around this problem
thanks JJ
I get this error message
The conversion of char data type to smalldatetime data type resulted in an out-of-range smalldatetime value.
when try to insert the code below
theMonth = "dbo.tbl_banners" & Month(Today())
MM_editTable = "dbo.tbl_banners" & Month(Today())
MM_editTable = "insert into " & MM_editTable & " (agencyID,month) VALUES (" & Request("agencyID") & ",'" & Today() & "')"
can anyone tell me how to get around this problem
thanks JJ