Return a date in the future from a given date

[CFP - Jason]

can anyone explain to me how to use this? i have a date and a frequency and i want to calculate the next event. I am refering to the example on mvps. Where do i put this code and howcan i store it so that i can use a query to find upcoming events. thanks i really need help on this one quick
Jason

 

[CFP - Jason]

is that the calc you use when querying, or is that for the field.
on the same note, i already got the intervals to calculate how i want them, so i guess my definitive question is how to build a query that can look for the calculated dates that fall in a range of say a week or 2 weeks etc. thanks greatly
Jason

 

[mission2java_78]

You don't need to store the calculated date, you can calculate it in the query. For example:

Select ...
From ...
Where YourDate Between Date() + 21 AND Date() + 30;

If your interval is something other than days, you'll need to use the DateAdd() function to add the inteval.

Shouldn't you be using the DateAdd function instead?
I've noticed using

Date()+30

Returns some unexpected results in comparisions at times.

Jon