Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

last Month

Status
Not open for further replies.
EasyOnly

EasyOnly

Technical User
Oct 11, 2008
55
US
Hi All,

I am trying to specify the end date for a query to pull data up to last month and to pull the data that has no end date.

So the end date will have criteria of is null....

Any suggestion for last month....
 
Sort by date Sort by votes
In the End date criteria cell:
Is Null OR <= DateSerial(Year(Date()),Month(Date()),0)

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

Swi
  • Locked
  • Question
12 Month Rolling Average 2
Replies
15
Views
1K
Swi
Swi
supportsvc
  • Locked
  • Question
Distinct Count for Unique Number of Employees in Each Month
Replies
0
Views
222
supportsvc
supportsvc
supportsvc
  • Locked
  • Question
Previous Quarter Sum and Last Quarter Sum in 1st Q the Following Year 1
Replies
12
Views
461
supportsvc
supportsvc
Lavenderchan
  • Locked
  • Question
Return Records for last 5 years 1
Replies
1
Views
166
dhookom
dhookom
0sprey
  • Locked
  • Question
Query by Month-Year and with a Record Count Field
Replies
1
Views
279
SkipVought
S

Part and Inventory Search

Sponsor

Back
Top