I have been asked to update this web app however I have never programmed in whatever this is written in, I think it was copied over from C++
This statement returns all records and sorts by ID
Case "initial Date"
If strSrchType = "Equals" Then ( this is just a drop down select)
sqlString = "SELECT * FROM TableName WHERE InitialDate=""" & strSrchFor & """ AND InitialDate >= " & strSrchFor & " ORDER BY ID, InitialDate"
what I would like this statement to do is add 5 years to the initial date and return those records greater then today's date that do not have a disqualified checkbox = true
I would sooner not have to enter anything in the strSrchFor field , I would rather just select the search now button that is already there.
initial date is initialDate
disqualified check box is disqualified
name is ID