AnsweredAssumed Answered

Report Expiry Date of items in 2 months

Question asked by TraceyLillis on May 5, 2011
Latest reply on May 5, 2011 by raybaudi


Report Expiry Date of items in 2 months


Hello, I am very new to FM, so please be easy with me!  :)

I have found a similar post, however I cannot get my script to work and I cannot find another solution on the web or in the FM Help section. LaRetta on the 2 May suggested this for the solution, however I cannot get it to work. 

Go to Layout [ list layout based upon Memberships ]
Enter Find Mode [ uncheck pause ]
Set Field [ ExpirationDate ; "< " & Get ( CurrentDate ) + 30 ] ... this is Phil's suggestion
Set Error Capture [ On ] ... this suppresses the FM message if no records are found and allows you to handle it yourself
Perform Find [ ]

Currently I have some fields that have certificate completion dates (e.g. First Aid).  Another field has a calculated result for 3 years time, (First Aid Expiry), which has the formula

Date ( Month ( First Aid ) ; Day ( First Aid ) ; Year ( First Aid )+3 )

I am now trying to run a weekly report (maybe with a button control using a script?) so that staff can find out which people have certificates that are going to expire in 2 months time.  This should then give the person time to find and complete a new course before their certificate expires. 

I have been trying to use the formula preclinicals::First Aid Expiry < Get ( CurrentDate ) + 60  (as 60 days will be close enough to 2 months), however it is not working as it is not showing any records at all. 

I would really appreciate it if someone could help me with my formula.  Should I be using a script or just a regular saved find for this type of search?  I want staff to just click a button and it show up the records on a report, sorted by location.

I look foward to hearing from someone.