View Full Version : Date Parameter Query


lilmosweet
09-25-2009, 10:49 AM
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
09-25-2009, 10:52 AM
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
09-25-2009, 11:15 AM
Thanks! You are the best! Have a great weekend!

boblarson
09-25-2009, 11:25 AM
Thanks! You are the best! Have a great weekend!
¡No problema! Have a great weekend yourself as well :)