AnsweredAssumed Answered

Current Date = Expiration Date

Question asked by HWRE on Oct 31, 2009
Latest reply on Nov 21, 2009 by HWRE


Current Date = Expiration Date


Data base is on Windows XP and using FM Pro 9 Advanced  setup on IWP


I have a value list (Field name "Status"). The value list has a dropdown list with the terms Active, Pending, Sold, Cancelled, Withdrawn, and Expired. I also have a date field with the Expiration date previously entered. How can I have the Status field automatically change from ACTIVE to EXPIRED when Current Date = Expiration Date.


I would also want it to change Contingent to Expired on the = date


And Pending to SOLD on a given date