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 Wanet Telecoms Ltd on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Getting Information for the previous month 1

Status
Not open for further replies.
dk99

dk99

MIS
Jun 20, 2003
76
GB
Is there a way I can get a query to pull out information for the previous month.

ie. if I run the query on the 1st June I need it to pull out information for 1st - 31st May.

I cant use <Now()-30 because some months have 31 days so any ideas will be appreciated.
 
Sort by date Sort by votes
In the criteria cell use:
>= Dateserial(year(now),month(now)-1,1) and < Dateserial(year(now),month(now),1)
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

TomSalvato
  • Locked
  • Question
Getting the Monday date from a week number 1
Replies
2
Views
858
TomSalvato
TomSalvato
caykamanj1966
  • Locked
  • Question
Enter information automatically
Replies
5
Views
380
Andrzejek
Andrzejek
TrekBiker
  • Locked
  • Question
This is the source query for what 1
Replies
12
Views
670
dhookom
dhookom
TechieJr
  • Locked
  • Question
Filtering for null or empty field
Replies
8
Views
1K
dhookom
dhookom
BallunarCrew
  • Locked
  • Question
Looking for a color chart 1
Replies
2
Views
333
BallunarCrew
BallunarCrew

Part and Inventory Search

Sponsor

Back
Top