return records from some date and last 30 days

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

rascal - 29 Apr 2006 14:00 GMT

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.

Reply to this Message

John Spencer - 29 Apr 2006 14:18 GMT

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
[quoted text clipped - 5 lines]
> done wrong and how do i correct it.
> Thanks for your help.

Reply to this Message

rascal - 29 Apr 2006 15:44 GMT

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.
>
[quoted text clipped - 14 lines]
> > done wrong and how do i correct it.
> > Thanks for your help.

Reply to this Message