AnsweredAssumed Answered

script to filter a report

Question asked by HeidiStewart on Apr 10, 2013
Latest reply on Apr 11, 2013 by philmodjunk


script to filter a report


     I created a report that i will run monthly to show those students whose Proposal is due within the next 30 days, but i need to filter out all those students whose proposal has already been completed.

     I have a calcuation field (c_MSc Proposal Due) which adds 6 or 8 months to the start date to get their proposal due date. 

     I have a date field (MSc Proposal Complete), when the student completes their proposal i put the date completed in.

     how do i write a script that i can attach to my Report layout that will automatically filter the records, as described above?