I am trying to set up an automatic way to expire old quotes in JobBOSS. I would like Event Manager to query all quote numbers that are expired by 30 days and change the status from open to expired.

I would be looking up the RFQ table and changing the Status column.

I can do all the look ups but I don't know how to write the portion that will make the change.

Any help?

Manville

I got this one figured out.

UPDATE RFQ
SET Status='Expired'
WHERE status = 'Active' and Expiration_Date <'{%Last Month Start Date%}'