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?