Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. PelicanProductions

    If calculation resultTwo equals field contents

    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...
  2. PelicanProductions

    Date Validation where variable represents the date

    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?
  3. PelicanProductions

    Date Validation where variable represents the date

    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...

Part and Inventory Search

Back
Top