Display Date Criteria in Report Footer?

  • Thread starter Thread starter Todd D. Levy
  • Start date Start date
T

Todd D. Levy

I have a report with a date field in the query that I use to return only
records from the previous calendar month (based on the month the report
is run in)

I use this criteria:

Between DateSerial(Year(Date()),Month(Date())-1,1) And DateSerial(Year
(Date()),Month(Date()),0)

I would like to have the month & year that the returned records are from
displayed in the report footer.

Is this possible?
 
="Between " & DateSerial(Year(Date()),Month(Date())-1,1) & " And " &
DateSerial(Year(Date()),Month(Date()),0)
 
In article <uLe7k#[email protected]>,
(e-mail address removed) says...

Duane,

Unfortunately, this does not work.

It returns a value of -1 which represents 1 month prior to the current
month. This is what it does as a criteria to grab the prior month's
records, but is not useful for displaying the actual month & year.

Any other suggestions?
 
Back
Top