Month(Date())

froggiebeckie

Registered User.
Local time
, 23:06
Joined
Oct 11, 2002
Messages
104
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
 
Make a Column Year([Test Date]) with criteria of Year(Date())
 
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
 

Users who are viewing this thread

Back
Top Bottom