AnsweredAssumed Answered

Current Date = Expiration Date

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

Title

Current Date = Expiration Date

Post

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

Outcomes