1 Reply Latest reply on May 5, 2011 8:03 AM by raybaudi

    Report Expiry Date of items in 2 months

    TraceyLillis

      Title

      Report Expiry Date of items in 2 months

      Post

      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.

      Regards

      Tracey