Dateserial question

  • Thread starter Thread starter Liz Taylor
  • Start date Start date
L

Liz Taylor

Hi,

I'm struggling with this one, simply because I just don't understand it all
yet... So, I'm hoping someone could set me straight.

I need to look at dates between 10/01/02 through today's date minus one
year... So if I look at the numbers today I would see data between 10/01/02
and 1/13/03.

I have the following which will give me 10/01/02 through today's date. How
do I modify this to show 10/01/02 through today's date minus one year...

Between DateSerial(IIf(Month(Date())<10,Year(Date())-1,Year(Date())),10,1)
And Date()

Thanks!!

Liz
 
You might try:

Between DateSerial(2002, 10, 1) And DateAdd("yyyy", -1, Date())

This assumes that the current date is after October 1, 2003, and that the
field you're using this expression as a criteria for is a Date/Time field
that does not have a time of day component.
 
You might try:

Between DateSerial(2002, 10, 1) And DateAdd("yyyy", -1, Date())

This assumes that the current date is after October 1, 2003, and that the
field you're using this expression as a criteria for is a Date/Time field
that does not have a time of day component.
Click to expand...
Between #10/1/2002# and DateAdd("yyyy",-1,Date())
 
Thanks. It works.

:-)


Brian Camire said:
You might try:

Between DateSerial(2002, 10, 1) And DateAdd("yyyy", -1, Date())

This assumes that the current date is after October 1, 2003, and that the
field you're using this expression as a criteria for is a Date/Time field
that does not have a time of day component.
Click to expand...
 
Back
Top