J
John J.
In a calculated field I'm trying to show the number of previous month
requests:
=DCount("[ID_request]";"tbRequest";"month([Date_entry]) =
month(DateAdd('m';-1;Now())) AND year([Date_entry]) =
year(DateAdd('m';-1;Now()))")
Although this formula is accepted it results in an ?error.
The formula for the current month does work:
=DCount("[ID_request]";"tbRequest";"month([Date_entry]) = month(Now()) AND
year([Date_entry]) = year(Now())")
Can't I use dateadd in a calculated field or am I doing something wrong?
Thank you,
John
requests:
=DCount("[ID_request]";"tbRequest";"month([Date_entry]) =
month(DateAdd('m';-1;Now())) AND year([Date_entry]) =
year(DateAdd('m';-1;Now()))")
Although this formula is accepted it results in an ?error.
The formula for the current month does work:
=DCount("[ID_request]";"tbRequest";"month([Date_entry]) = month(Now()) AND
year([Date_entry]) = year(Now())")
Can't I use dateadd in a calculated field or am I doing something wrong?
Thank you,
John