Change Between by DateDiff or DateAdd.

[wagner.bts]

Hello.



I would like to know, if there's anyway for me to make a query like this:

Between #30/01/2009# And #30/06/2009#

Using some function.


Using between, I have to change the dates everyday manually.

Tks

[RuralGuy]

You can use variables:
Between StartDate AND EndDate
...and set the variables in code.