Calculating days between Start Date and Today ?

[jj1]

Hi I have form which automatically takes a start value for today the fieldname is Date.


now what I want to do is calculate the difference between Date and Today's date in days with 2 criteria's
Ist criteria will be choosing the field which has a boolean field named Was Issue Resolved and has value as Null or False
and second criteria will be to show only days with greater than 21 days

This is what I m trying to do

Expr3: DateDiff("d",[Date],[date()])

but gives me error on date() as it can't find this parmater

I tried this also
>=DateAdd("d",-21,Date())

But its not population difference between the Date and Today Date

Please Help

[John_G]

Try removing the square brackets in this expression:

Change : Expr3: DateDiff("d",[Date],[date()])
to
Expr3: DateDiff("d",[Date],date())

Also, I strongly suggest that you rename the [Date] field - "Date" should be considered a reserved word, even though it often does work as a field name, because if you forget the square brackets, the results will be unpredictable.

John