IF / NOTHING statement Time issue

IF / NOTHING statement Time issue

Good morning,

My arguments with the coding i've inherited continue, and being a monday morning my head isn't quite ready for it yet....

Quite straightforward, I've added to our checkout system an extra field in the INSERT commands to add the order date and time to the database, so it can print out on the customer's invoice.

So I figured on (the printed invoice) using a simple IF command to check if the order has a time on it in the first place, and if not, just produce a default value. Trouble is, i get a BC30035 Syntax error, even though it looks ok to me!!!

Code:

Line 196: If objRS.Fields("OrderTime").Value Is Nothing
Line 197: then OrderTime = "2009-01-01 00:00:00"
Line 198: Else OrderTime = objRS.Fields("OrderTime").value
Line 199: End Ifas

View Full Details...............................