I'm currently using the datediff command to find the # of days between two dates...however I want to be able to subtract that from the datediff of two other numbers. Ofcourse, to no avail, I can't seem to get datediff to work with embedded parenthesis?
Expr2...
Can you use the COUNT function with criteria?
For Example: I want to count all dates(same field or multiple fields) that are two weeks old.
Can't seem to use COUNT if I have something in criteria?
I hate to ask for help but I'm running out of time to research this.
I have a report that needs to show records that were entered for the past 14 days grouped by individual. That's the easy part. The sticking part for me is counting each date entered that is within the past 14 days.
There...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.