I solved a "Error converting data type nvarchar to datetime" problem with the help of this forum. The thing simply was to convert a date, say StartDate to Ctype(StartDate, Date).
Now that I did this for all dates in the AdminDB.vb file, I get the following error while trying to remove Expiry Date from Site Settings : Cast from string "" to type 'Date' is not valid
How can I correct this ?
thanks for your help
Website - Weblog
Well, I had same problem with Banner's Start Date and End Date, this is what I suggest You:
Dont' use IIf(...) but something like this:
If ExpiryDate = "" Then
MyExpiryDate = SqlInt16.Null
MyExpiryDate = CType(ExpiryDate, Date)
Lemme know how it goes!