DateDiff() Calculation

[mlcampeau]

Hi guys. I know I've seen this somewhere, but when I need the answer, I can't seem to find it. This should be relatively simple. I'm trying to add criteria to a query so that it only shows people whose performance review date is within one month. So, it should display all names where [PerformanceReviewDate] is between Today and one month from today. I think I should be using the DateDiff() function, but I've never used it before and am unsure of the syntax. Any guidance would be appreciated. Thanks.

[FishVal]

Hi guys. I know I've seen this somewhere, but when I need the answer, I can't seem to find it. This should be relatively simple. I'm trying to add criteria to a query so that it only shows people whose performance review date is within one month. So, it should display all names where [PerformanceReviewDate] is between Today and one month from today. I think I should be using the DateDiff() function, but I've never used it before and am unsure of the syntax. Any guidance would be appreciated. Thanks.

Hi, there.

something like this

SELECT tbl.* FROM tbl WHERE DateDiff("m", Date, tbl.[PerformanceReviewDate])<1;
 

[mlcampeau]

Hi, there.

something like this

SELECT tbl.* FROM tbl WHERE DateDiff("m", Date, tbl.[PerformanceReviewDate])<1;
 

Worked perfectly! Thanks!