How Can I set one field to "Complete," when another field is Older than 6 months?

[matt1000]

Hello All,

I am attempting to update a "Completed" status field to "Complete" if an "Original_Sub" field is 6 months older than the sys date. Any ideas on how this can be done with sql?



Thanks in advance for anyones help!

Regards,

Matt r.

[pbaldy]

How about

UPDATE TableName
SET FieldName = "Complete"
WHERE DateFieldName < DateAdd("m", -6, Date())

[matt1000]

pbaldy,

Thanks a ton!! It worked fantastically. I only mad a few changes. Here they are below:


UPDATE tblAnalysis_file SET tblAnalysis_file.completed = "Complete", tblAnalysis_file.chart = "Disregard", tblAnalysis_file.status = "Submission Date > 6 Months", tblAnalysis_file.comments = "Failed Submission not Reactivated"
WHERE (((tblAnalysis_file.[original_sub])<=DateAdd("d",-180,Date())) AND ((tblAnalysis_file.[completed])<>"Complete"));


Thanks again!!!!

Regards,

Matt r.

[pbaldy]

Happy to help Matt, and welcome to the site by the way!