Making todays date format to just month

  • Thread starter Thread starter Lisa
  • Start date Start date
L

Lisa

Hello,

Is there any way to format the Now() statement to only
show the month in a number format besides changing the
format field to "mm"? I want to sort on everything dated
in this month before the end of the month.
For example: I have something dated to end 4/30/04 and
want to pick it up even though today is 4/21/04. Is it
possible?

Thanks in advance,
Lisa
 
Hello,

Is there any way to format the Now() statement to only
show the month in a number format besides changing the
format field to "mm"? I want to sort on everything dated
in this month before the end of the month.
For example: I have something dated to end 4/30/04 and
want to pick it up even though today is 4/21/04. Is it
possible?

Thanks in advance,
Lisa
Click to expand...

If you wish you could use Month(Now()), or better yet, Month(Date()).

Where Month([DateField]) = Month(Date())
will return all records for the month of April (for all years!!!)

You would be better off using:
Where Format([DateField],"mm/yyyy") = Format(Date(),"mm/yyyy")
to restrict records to April of this year only (if that is what you
really mean).
 
Back
Top