Date = Request.Form("Date") rs("Date") = Date If rs("Date") <= Date() Then rs("Confirmed") = true Else rs("Confirmed") = false End If