Page 1 of 1
Use calculated field in the filter
Posted: Tue May 05, 2009 10:49 am
by 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?__
=> Use calculated field in the filter
Posted: Wed May 06, 2009 4:03 pm
by 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
==> RE: Use calc field in the filter
Posted: Thu May 07, 2009 7:30 am
by 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