R
rciolkosz
I have a full date.time stamp field and need a query to only pull records for
the current month and following month.
the current month and following month.
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
G
Golfinray
In the query criteria, type Between 5/1/2008 and 6/30/2008
J
John Spencer
The Following should work
Field: YourDateField
Criteria: >= DateSerial(Year(Date()),Month(Date()),1) AND <
DateSerial(Year(Date()),Month(Date())+ 2,1)
OR if your field never has midnight as the time
Field: YourDateField
Criteria: Between DateSerial(Year(Date()),Month(Date()),1) AND
DateSerial(Year(Date()),Month(Date())+ 2,1)
John Spencer
Access MVP 2002-2005, 2007-2008
Center for Health Program Development and Management
University of Maryland Baltimore County
Field: YourDateField
Criteria: >= DateSerial(Year(Date()),Month(Date()),1) AND <
DateSerial(Year(Date()),Month(Date())+ 2,1)
OR if your field never has midnight as the time
Field: YourDateField
Criteria: Between DateSerial(Year(Date()),Month(Date()),1) AND
DateSerial(Year(Date()),Month(Date())+ 2,1)
John Spencer
Access MVP 2002-2005, 2007-2008
Center for Health Program Development and Management
University of Maryland Baltimore County
R
rciolkosz
I understand that. I want to use the computer time so that the query will
automatically display the current month plus the next.
automatically display the current month plus the next.
M
Michel Walsh
DateDiff("m", now, yourDate) IN (0, 1)
will return true if your date is in the current month, or in the next month.
Hoping it may help,
Vanderghast, Access MVP
will return true if your date is in the current month, or in the next month.
Hoping it may help,
Vanderghast, Access MVP
R
rciolkosz
AWESOME! PERFECT. Thank you
John Spencer said:The Following should work
Field: YourDateField
Criteria: >= DateSerial(Year(Date()),Month(Date()),1) AND <
DateSerial(Year(Date()),Month(Date())+ 2,1)
OR if your field never has midnight as the time
Field: YourDateField
Criteria: Between DateSerial(Year(Date()),Month(Date()),1) AND
DateSerial(Year(Date()),Month(Date())+ 2,1)
John Spencer
Access MVP 2002-2005, 2007-2008
Center for Health Program Development and Management
University of Maryland Baltimore County