Use calculated field in the filter

[Jane_B_(Guest)]

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 should it be, or is this impossible with a calculated field?__

[kfleming]

[updated:LAST EDITED ON May-06-09 AT 04:07 PM (EST)]It may be that CONTDATE is a datetime field rather than a date field.____Try creating a calculated field using the expression TODATE(CONTDATE)____Kathleen__R&R Support

[Jane_B_(Guest)]

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