Search found 2 matches

by Jane_B_(Guest)
Thu May 07, 2009 7:30 am
Forum: R&R ReportWorks Users
Topic: Use calculated field in the filter
Replies: 2
Views: 1462

==> RE: Use calc field in the filter

Thank you Kathleen, that eventually worked when I created another calculated field for the CONTDATE using TODATE(), so I was filtering like for like!____Thanks again____Jane
by Jane_B_(Guest)
Tue May 05, 2009 10:49 am
Forum: R&R ReportWorks Users
Topic: Use calculated field in the filter
Replies: 2
Views: 1462

Use calculated field in the filter

I^ve calculated a date field CONTHIST = SUBDAYS(LEAVEDATE,10)which takes 10 days off the members leave date.__I then want to use this in the filter__....AND CONTDATE >= CONTHIST. However when listing the values that can be used in this filter line CONTHIST isn^t there to be chosen and my question is...