date calculation from today

[userid128223]

Hi I am looking for equation that will do following.

Fields:

ServicePurchaseDate

hours purchase

hours worked

if ServicePurchasedate is less then 12 months (from current selection) (or from today)  then hours purchase - hours worked. if not then show 0. If hours worked acceds hours purchase then show negative number

[#2]

Hi,

just to be sure to well understand your question, could you please give us an example of what you're looking for?

Thanks

Giampiero

[yvesqlik]

if(year2date(ServicePurchaseDate),hours purchase-hours worked,0)

[userid128223]

if ServicePurchaseDate is less then 12 months from current date, then hours purchase - hours worked.

thanks

[swuehl · Accepted solution]

Maybe something like

=if([ServicePurchaseDate] > addmonths( today() ,-12), [hours purchases] - [hours worked],0)