Show data older than six months based on a database field

system · November 16, 2009, 10:07pm

=If([Close Date]<CurrentDate()-180;0;1)
but it doesn’t like -180, says it’s an invalid data type.

However, =If([Matter Close Date]<CurrentDate();0;1) works fine.

Any ideas how I can get this?

Thanks.

FSmith37 (BOB member since 2009-11-16)

system · November 16, 2009, 10:15pm

Please, look at the Web Intelligence function RelativeDate.

Andreas (BOB member since 2002-06-20)