Date Parameter Query

[lilmosweet]

I have a Date Parameter set up in my query for the user to input the start date but I need the result to return only 60 days after the input start date from the user. How do I achieve this in my access query?

Thanks!

 

[boblarson]

I have a Date Parameter set up in my query for the user to input the start date but I need the result to return only 60 days after the input start date from the user. How do I achieve this in my access query?

Thanks!

The parameter should be:

>=[Enter Start Date] AND <=DateAdd("d",60,[Enter Start Date])

 

[lilmosweet]

Thanks! You are the best! Have a great weekend!

 

[boblarson]

Thanks! You are the best! Have a great weekend!

¡No problema! Have a great weekend yourself as well