Month(Date())

[froggiebeckie]

Morning!
I have a column in a query set up as:

DateFormula: Month([Test Date])

Table and Sort are left blank

Criteria is Month(Date())

I was expecting to get records from the current month (Jan 2007).
What I'm actually getting are records from ANY January (2004, or 2006 etc).

Any idea what I need to do differently to get only current month records?

Thanks,

BeckieO

 

[KeithG]

Make a Column Year([Test Date]) with criteria of Year(Date())

 

[Krava]

Hi, Beckie!

Yes, I think.

One way is: You only change your Month([Test Date]) into Year([Test Date]) & Month([Test Date]), and your criteria to Year(Date()) & Month(Date()).

Hope it helps.

Krava

 

[froggiebeckie]

Works like a charm, folks.
As always, y'all are the best.

Thanks
BeckieO