Search found 2 matches
- Thu May 07, 2009 7:30 am
- Forum: R&R ReportWorks Users
- Topic: Use calculated field in the filter
- Replies: 2
- Views: 1504
==> 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
- Tue May 05, 2009 10:49 am
- Forum: R&R ReportWorks Users
- Topic: Use calculated field in the filter
- Replies: 2
- Views: 1504
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...