Year to Date date restrictor

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

ChuckW - 22 Nov 2005 19:58 GMT

Hi,

I want to create a year to date date restrictor. Right now for all of my
queries I have used between 1/1/05 and 12/31/05. I want to create one that
will automatically roll over to the next year raither than changing it to
1/1/06 and 12/31/06. Can anyone help?

Thanks,

Signature

Chuck W

Reply to this Message

Rick Brandt - 22 Nov 2005 20:31 GMT

> Hi,
>
[quoted text clipped - 4 lines]
>
> Thanks,

BETWEEN DateSerial(Year(Date()), 1,1) AND Date()

Signature

I don't check the Email account attached
to this message. Send instead to...
RBrandt at Hunter dot com

Reply to this Message

fredg - 22 Nov 2005 21:20 GMT

> Hi,
>
[quoted text clipped - 4 lines]
>
> Thanks,

Where Year([DateField] = Year(Date())
or
Where Format([DateField],"yyyy") = Format(Date(),"yyyy")
or
Where [DateField] Between DateSerial(Year(Date()),1,1) and Date()
or if some of your records are dated into the future of the current
year ...
Where [DateField] Between DateSerial(Year(Date()),1,1) and
DateSerial(Year(Date()),12,31)

Signature

Fred
Please respond only to this newsgroup.
I do not reply to personal e-mail

Reply to this Message