DateAdd Function for and ENTIRE Month

  • Thread starter Thread starter CBender
  • Start date Start date
C

CBender

I ahve a query where I want to select date data for the entire month. This I
can easily do using the following format:

Field: Month: Month([RevicedDateShipInv_PGI])
Criteria: Month(Date())

This provides me with every order within the current month.

However, when I try to select the same date information for the following
month using the DateAdd function as follows I get NO results:

Field: Month: Month([RevicedDateShipInv_PGI])
Criteria: DateAdd("m",+1,Month(Date()))

Can anyone tell me what I am doing wrong??


Thanks,

Chip
 
DateAdd("m",+1,Month(Date()))
You are trying to add a months worth of days to the month number -
month=3 30+3 = 33 and that does not match next month number
 
Criteria should be

Month(DateAdd("m",1,Date()))

One problem with that is you are going to get the month for EVERY year.
If that is what you want, then this is no problem.

'====================================================
John Spencer
Access MVP 2002-2005, 2007-2009
The Hilltop Institute
University of Maryland Baltimore County
'====================================================
 
Karl,

Thank you. I already understand that I am writing the wrong code because I
am not getting ANY results much less the results I want. I want to extract
all of the records for the following month in my query. I am not a
programmer and am self taught in MS Access so I am very much behind the
learning/knowledge curve when it comes to resolving coding issues. Can you
provide me with the CORRECT code I should be using?


Thank You,

Chip


--
Charles Bender
MTU Detroit Diesel


KARL DEWEY said:
DateAdd("m",+1,Month(Date()))
You are trying to add a months worth of days to the month number -
month=3 30+3 = 33 and that does not match next month number

--
KARL DEWEY
Build a little - Test a little


CBender said:
I ahve a query where I want to select date data for the entire month. This I
can easily do using the following format:

Field: Month: Month([RevicedDateShipInv_PGI])
Criteria: Month(Date())

This provides me with every order within the current month.

However, when I try to select the same date information for the following
month using the DateAdd function as follows I get NO results:

Field: Month: Month([RevicedDateShipInv_PGI])
Criteria: DateAdd("m",+1,Month(Date()))

Can anyone tell me what I am doing wrong??


Thanks,

Chip
Click to expand...
Click to expand...
 
Back
Top