Trying to update a table called 'tblPerson' to close off users who are inactive from a specified date.
Column 1: 'createDate'
Boolean to update: 'closed' (by default set to 0) False (meaning the account isn't closed)
I want to query the database to close from a certain date specified below, anything older than that I want to set 'closed' to = 1
This is what I have come up with below, but doesn't seem to work
SET closed = 1
WHERE createDate < 19072010 0:00:00
If anyone could shed some light, or help out with the code it would be much appreciated