End of Month Expression for Query Question

  • Thread starter Thread starter DannyD
  • Start date Start date
D

DannyD

I think I have a simple question. I want to create a query to list tasks with
target completion dates scheduled before the end of the current month. I have
been unable to determine if there is an end of month expression I can plug
into a query designed by the Access 2000 wizard. Is there such an expression
(such as "Date()" for the current date)?

TIA - Danny
 
There are probably simpler ways but this will do it.
DateAdd("m",1, Date()) - Day(DateAdd("m",1, Date()))
 
If you are saying you want to filter a query for records in the current month:
WHERE Month([Completion Date]) = Month(Date())
 
I think I have a simple question. I want to create a query to list tasks with
target completion dates scheduled before the end of the current month. I have
been unable to determine if there is an end of month expression I can plug
into a query designed by the Access 2000 wizard. Is there such an expression
(such as "Date()" for the current date)?

TIA - Danny
Click to expand...

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

works for me...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

query filter for end of current month 3
End of Month: Parameter Query? 3
Excel Message box with days of month & date. 1
Return all dates for 'next month' irrespective of year or day 4
DATE EXPRESSION 4
Filtering by Month 1
Query that 2
Excel VBA to go to specific sheet & cell in the current workbook not working. 2

Back
Top