How to have a date range equal a particular month

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

What is the expression for converting multiple dates mm/dd/yyyy to the
coinsiding month?
 
It is according to how you are going to use the data but try this --
Format([YourField], "yyyymm")
This will give you 200711 for this month.
Format([YourField], "mmmm yyyy")
This will give you November 2007 for this month.
 
Format(DateField, "yyyy-mm") as string 2007-11

or
Month(DateField) returns the month number and Year(DateField) returns the
year number
11 and 2007 in separate fields

Or to get a date field that is the first day of the month
DateSerial(Year(DateField),Month(DateField),1)
Nov 1, 2007 (US format: 11/1/2007)

--
John Spencer
Access MVP 2002-2005, 2007
Center for Health Program Development and Management
University of Maryland Baltimore County
..
 
Karl, This worked! Thank you very much!

KARL DEWEY said:
It is according to how you are going to use the data but try this --
Format([YourField], "yyyymm")
This will give you 200711 for this month.
Format([YourField], "mmmm yyyy")
This will give you November 2007 for this month.

--
KARL DEWEY
Build a little - Test a little


tvillare said:
What is the expression for converting multiple dates mm/dd/yyyy to the
coinsiding month?
Click to expand...
Click to expand...
 
What is the expression for converting multiple dates mm/dd/yyyy to the
coinsiding month?
Click to expand...

One useful way to take an arbitrary date and convert it to criteria to search
for records within that month is to use a criterion such as
= DateSerial(Year([Enter date:]), Month([Enter date:], 1) AND < DateSerial(Year([Enter date:]), Month([Enter date:] + 1, 1)
Click to expand...

Replace [Enter date:] by a form reference if that's what you're using as a
criterion.

John W. Vinson [MVP]
 
Back
Top