C
Chad
Hello, in my query I have two fields and an expression.
1) EmployeeName
2) PeriodRatedTo
3) Expression= DueDate: DateAdd("d",-30,[PeriodRatedTo]) and a Criteria:
Date()
What I want the query to do is show the EmployeesName and the PeriodRatedTo
date but I want it to show only 30 days prior to the PeriodRatedTo date. I
keep getting no results... Is my formula wrong? thanks!
1) EmployeeName
2) PeriodRatedTo
3) Expression= DueDate: DateAdd("d",-30,[PeriodRatedTo]) and a Criteria:
Date()
What I want the query to do is show the EmployeesName and the PeriodRatedTo
date but I want it to show only 30 days prior to the PeriodRatedTo date. I
keep getting no results... Is my formula wrong? thanks!