Hello!

This should be easy, but is not working for some reason.

I would like to return a value in a number field of 0 if the date in a specific field is more than six months ago, or 2.5 if the date is within six months.

My formula is currently:

If( Proof_of_Address_Date__c  >  TODAY() +180, 2.5, 0)

But this is not providing the correct result.

Any help would be really appreciated. Thanks so much.

Hello!

This should be easy, but is not working for some reason.

I would like to return a value in a number field of 0 if the date in a specific field is more than six months ago, or 2.5 if the date is within six months.

My formula is currently:

If( Proof_of_Address_Date__c  >  TODAY() +180, 2.5, 0)

But this is not providing the correct result.

Any help would be really appreciated. Thanks so much.