For some reason I can’t get my calculated query field to recognize a day interval. Every time I test run the form that displays the query results, a parameter pop-up asks me to enter the value of d.
My sql column formula is the following:
ExceedsTime: (IIf(IsNull([CloseOutDate]) And (DateDiff(["d"],[SurveyDate],Now())>45),1,0))
Basically I need to count any results where the Survey has not been completed within the 45-day deadline.
If we’re running past the deadline, return a 1 value toward the total count. If we’re still within the 45-day window, return a 0 value.
SurveyDate = Day the survey was conducted
CloseOutDate = Day the survey is completed.
I’ve tried it anyway my peanut brain can reword it.
Is there any way I can make it recognize day as any interval and not a parameter value?
Melissa Hersh is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.