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 Mike Lewis 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: *
- Users: PelicanProductions
- Order by date
-
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...- PelicanProductions
- Thread
- Replies: 1
- Forum: FileMaker Inc.: FileMaker Pro
-
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?- PelicanProductions
- Post #3
- Forum: FileMaker Inc.: FileMaker Pro
-
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...- PelicanProductions
- Thread
- Replies: 3
- Forum: FileMaker Inc.: FileMaker Pro
