Topic: Compare two dates and update Fields
Hi,
I just need to have a query to update my records by compare two dates!
But cannot manage to make it
something like this :
UPDATE sampletable SET myfield=1 where DATEDIFF(TODAY,DATEFIELD) >= 7;
so How can I do it ?
Thanks a lot