Basic Date Question (1 Viewer)

[tsukeepr]

I have a database that I want to only pull the entries from the current month up, I can't remember how to do this. could someone please help me.

 

[thouston]

Suppose your date column is called "dateval".

Then make a query and put Month([dateval])=Month(Now()) in the select criteria. Should work!

 

[tsukeepr]

not working

For some reason, when I enter in that formula, it only gives me the entries for the last two days, nothing from 8/2/2002.
I put the exact thing in the critiria part of the query, under the dateval feild. Am I doing something wrong?

Thank you for your help!

 

[thouston]

That's strange, it works for me. Though I did forget to make sure it was the current year if there's more than one stored, in which case you'd need
(Month([dateval])=Month(Now())) And (Year([dateval])=Year(Now()))

The only other thing is to check that your date format is what you intended - to my British eyes 8/2/2002 reads as 8th of feb....

 

[tsukeepr]

It works now, thank you very much for your help!!!