Expiration for the next year
Can you please help me build a script to find the expiry date of materials for the next year in my database.
Do you mean that you want to find all records where a date field has a date for the next year (2014 at the moment)?
Enter find Mode --->clear the pause check box
Set field [Yourtable::ExpiryDateField ; Year ( Get ( currentDate ) ) + 1 ]
Set error capture[on]
For more examples of scripted finds, see: Scripted Find Examples
Yes, I want to find the the date for the next year.
Retrieving data ...