return records from some date and last 30 days

[Guest]

Hi all:
I thought I had solved this problem, but I have discovered I haven't. I
have a query where I want a prompt for the user to enter a date and have only
the records returned from the date entered and the previous 30 days. I had
entered the following in the crtieria field: >=DateAdd("d",-30,[Enter
StartDate]) but it returns records for dates afterwards. For example when I
entered Apr 13 I will also get records from Apr 14 up to today. What have I
done wrong and how do i correct it.
Thanks for your help.

 

[John Spencer]

You need to set a limit with a range.

Between DateAdd("d",-30,[Enter StartDate]) and [Enter StartDate])

That gives you a 31 day range (If you enter Dec 31 2006, the calculation returns
Dec 1 2006) so you get all records between midnight Dec 1 and midnight Dec 31.
If your date field contains times you will need to change the above to get
records for the end date.

 

[Guest]

Thanks so much John,
I tried it out and it works the way I want it to,

You need to set a limit with a range.

Between DateAdd("d",-30,[Enter StartDate]) and [Enter StartDate])

That gives you a 31 day range (If you enter Dec 31 2006, the calculation returns
Dec 1 2006) so you get all records between midnight Dec 1 and midnight Dec 31.
If your date field contains times you will need to change the above to get
records for the end date.

Hi all:
I thought I had solved this problem, but I have discovered I haven't. I
have a query where I want a prompt for the user to enter a date and have only
the records returned from the date entered and the previous 30 days. I had
entered the following in the crtieria field: >=DateAdd("d",-30,[Enter
StartDate]) but it returns records for dates afterwards. For example when I
entered Apr 13 I will also get records from Apr 14 up to today. What have I
done wrong and how do i correct it.
Thanks for your help.