Query Problem

[DavidW]

I am trying to use

Between DateSerial(Year(Date()),Month(Date()),1) And
DateSerial(Year(Date()),Month(Date())+1,0)

to retrieve records for 1 year in a query. This is in the date field
critiria, what I am getting is on the current month,
Any Ideals to what I have done wrong?
David

 

[Ken Snell]

You're getting just the current month's records because that's what the
criteria expression is written to do.

If you want the records for the entire current year, add a calculated field
to the query:
DataYear: Year([DateTimeFieldName])

Put this criterion expression for the DataYear field:
Year(Date())

 

[Van T. Dinh]

If you want to get records for the coming year (365/366 days) then use:

Between Date()
And DateSerial(Year(Date()) + 1,Month(Date()),Day(Date()))

If you want to select records for the last 365/366 days then use:

Between DateSerial(Year(Date()) - 1,Month(Date()),Day(Date()))
And Date()

Adjust the expressions to suit your needs, especially if you store the
non-zero time component.