I am trying to create a SetField script step that validates a records status and changes the status to "Renewal" if the record has expired, here is the calculaton:
If (
RunSheet_PP::Date >= RunSheet_PP::Validate; "Renewal";"VARIABLE?"
)
Where I have "VARIABLE?" I am looking for a value that...
Thanks CryoGen, works great.
One more question, now that I have converted my text_based_date_field to dates how do I get Filemaker to compare the last issue date to the current date and display expired records?
Hello, I am building a subscription database for a quarterly publication and need to be able to identify records for expiring subscribers. The database contains a field for ending issue but the issue is identified by season and year ie. "Summer 2007". How can I specify that "Summer 2007" equals...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.