Changing Year in Date Range

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Jomark - 27 Feb 2008 18:24 GMT

I am using a crosstab query for selecting data for a date range spanning 12
months over two different years using a "Between & And" date range e.g
Between #01/04/07# And #31/03/08#

For the following 12 month period I can manually change the Year numbers in
the above criteria.

my question is: is it possible to change or select the Year number without
having to change it manually in the query design view by say a parameter box?

Reply to this Message

KARL DEWEY - 27 Feb 2008 20:12 GMT

Have you considered using this ---
Between CVDate("4/1/"&Format(Date(),"yyyy")) And
CVDate("3/31/"&Format(DateAdd("yyyy",1,Date()),"yyyy"))

Signature

KARL DEWEY
Build a little - Test a little

> I am using a crosstab query for selecting data for a date range spanning 12
> months over two different years using a "Between & And" date range e.g
[quoted text clipped - 5 lines]
> my question is: is it possible to change or select the Year number without
> having to change it manually in the query design view by say a parameter box?

Reply to this Message