problem with date criteria

[sbrooks1763]

I have a query in which i add a number of days to a given date. This gives the "next date due" for the particular function. In the criteria of the expression field, I have entered "between[start date] and [end date]. When I open this report, it prompts me to enter the dates I want to see reported. However, it doesn't limit the results to those dates or to the current year. Any ideas?

[orange]

I suggest you add some code to do a debug.print and to print out the underlying sql including your [start date] and [end date] values. Then post the sql for others to comment and advise.