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 Chriss Miller 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
Joined
Oct 11, 2008
Messages
55
Location
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 Question
12 Month Rolling Average
Replies
15
Views
2K
Swi
Swi
supportsvc
  • Locked
  • Question Question
Distinct Count for Unique Number of Employees in Each Month
Replies
0
Views
290
supportsvc
supportsvc
supportsvc
  • Locked
  • Question Question
Previous Quarter Sum and Last Quarter Sum in 1st Q the Following Year
Replies
12
Views
670
supportsvc
supportsvc
Lavenderchan
  • Locked
  • Question Question
Return Records for last 5 years
Replies
1
Views
242
dhookom
dhookom
0sprey
  • Locked
  • Question Question
Query by Month-Year and with a Record Count Field
Replies
1
Views
375
SkipVought
S

Part and Inventory Search

Sponsor

Back
Top