Help for creating custom filter

[dafnie]

Hi

I trying to make a custom filter i the report module.

I have a date-field "START WARRANTY" and a int-field "YEARS OF WARRANTY" and like to have a report showing only items with still having warranty.

Can anyone help with a formula for this job?

I think something like:

"START WARRANTY > datetime\addYears(datetime\now(), negate(TOTAL_WARRANTY))"

How can i subtract TOTAL_WARRANTY instead of addYears

Greetings from Denmark

[tanya]

Hello,
as I see this

YEARS OF WARRANTY is a duration in years?

datetime\today() >= START_WARRANTY && datetime\today() <= datetime\addYears(START_WARRANTY, YEARS_OF_WARRANTY)

if TOTAL_WARRANTY is a duration in years use it in formula like is a duration in (-1)*TOTAL_WARRANTY