Definition Query with start and end dates

MichaelScott2

I have data in an SQL database that has fields for a start date (StartDate) and end date (EndDate).

My client would like the features to be visible only when the current date is between the start date and 45 day after the end date.

I have tried many different definition query iterations and looked at a lot of forum posts. The closest I have gotten to a working definition query is...

GetDate() >= StartDate AND EndDate <= GetDate() - 45

I'd like the second part to be GetDate() <= EndDate + 45, but that gives me a syntax error.

I can't seem to wrap my brain around the logic for this definition query.

Any assistance would be greatly appreciated.

Thank you.

JoshuaBixby

Try:

 

 

GETDATE() BETWEEN StartDate and DATEADD(day, 45, EndDate)

 

 

or

 

GETDATE() >= StartDate AND GETDATE() <= DATEADD(day, 45, EndDate)