J
JohnW
I need to calculate multiple values for a field called CSP that will be based
on a calculated field called Days. Days is calculated by using
DateDifference which takes a Today Date field minus an inputted field, Start
Date. The CSP needs to return a decimal value or if none return a value of
zero. I am placing the expression in a query and have tried....
CSP: =IFF(AND([Days}>=365,[Days]<730),".05","0") which should return a value
of .05
CSP will be different for different values of the "Days" field so I want to
use many IFF expressions for the same field. For example using the above
example the next expression would be
CSP: =IFF(AND([Days}>=730,[Days]<1095),".10","0") which should return a
value of .10
Can I do this? And what would be the proper expression to return these
values?
Thanks for the help.
on a calculated field called Days. Days is calculated by using
DateDifference which takes a Today Date field minus an inputted field, Start
Date. The CSP needs to return a decimal value or if none return a value of
zero. I am placing the expression in a query and have tried....
CSP: =IFF(AND([Days}>=365,[Days]<730),".05","0") which should return a value
of .05
CSP will be different for different values of the "Days" field so I want to
use many IFF expressions for the same field. For example using the above
example the next expression would be
CSP: =IFF(AND([Days}>=730,[Days]<1095),".10","0") which should return a
value of .10
Can I do this? And what would be the proper expression to return these
values?
Thanks for the help.