One month out

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am trying to create a query for a Weight Management organization. They are
wanting to run a query that pulls the names of patients that have completed
the program and would need to be recalled 1 month after the [End Date] but
less than 3 months after the [End Date]. Is that possible? Thanks!
 
Under the [EndDate] in your query, put...


Date()-30 and < Date()-90
Click to expand...

(I think that is correct, I just did the math in my head and did not go test
it. You get the idea, though)

Rick B


Sue said:
I am trying to create a query for a Weight Management organization. They are
wanting to run a query that pulls the names of patients that have completed
the program and would need to be recalled 1 month after the [End Date] but
less than 3 months after the [End Date]. Is that possible? Thanks!
Click to expand...
 
Rick - I am having problems with the syntax. Would you clarify please?
Thanks!

Rick B said:
Under the [EndDate] in your query, put...


Date()-30 and < Date()-90
Click to expand...

(I think that is correct, I just did the math in my head and did not go test
it. You get the idea, though)

Rick B


Sue said:
I am trying to create a query for a Weight Management organization. They are
wanting to run a query that pulls the names of patients that have completed
the program and would need to be recalled 1 month after the [End Date] but
less than 3 months after the [End Date]. Is that possible? Thanks!
Click to expand...
Click to expand...
 
it basically says if the "enddate" is between 90 days ago and 30 days abo,
then pull it.

Isn't that what you want?

I think I have the operators wrong though. Try:
Date()-90 and <Date()-30
Click to expand...


Rick B



Sue said:
Rick - I am having problems with the syntax. Would you clarify please?
Thanks!

Rick B said:
Under the [EndDate] in your query, put...


Date()-30 and < Date()-90
Click to expand...

(I think that is correct, I just did the math in my head and did not go test
it. You get the idea, though)

Rick B


Sue said:
I am trying to create a query for a Weight Management organization.
Click to expand...
They
are
wanting to run a query that pulls the names of patients that have completed
the program and would need to be recalled 1 month after the [End Date] but
less than 3 months after the [End Date]. Is that possible? Thanks!
Click to expand...
Click to expand...
Click to expand...
 
Back
Top