Max Date

[Jeefgeorge]

I have a report showing Bid Information for various projects, including the
Field [Bid Date] which is formatted as Date/Time. In the footer of the report
I would like to show the most recent date from this field. I have tried to
use =max([Bid Date]) which returns #Error.

 

[Golfinray]

try using Dmax (which stands for Date Max)

 

[Jeefgeorge]

I used Dmax("[Bid Date]","Estimating Guide") works great....btw..Dmax stands
for Domain Max

try using Dmax (which stands for Date Max)

I have a report showing Bid Information for various projects, including the
Field [Bid Date] which is formatted as Date/Time. In the footer of the report
I would like to show the most recent date from this field. I have tried to
use =max([Bid Date]) which returns #Error.

 

[fredg]

I have a report showing Bid Information for various projects, including the
Field [Bid Date] which is formatted as Date/Time. In the footer of the report
I would like to show the most recent date from this field. I have tried to
use =max([Bid Date]) which returns #Error.

The Footer of the Report?
A report can have many Footers.
Do you mean the PAGE Footer?

You cannot use that expression in a report page footer.
Place that expression in the report Detail section. You can make it
Not Visible.
Then, in the page footer you can refer to that control.
=[NameOfControlInDetail]

 

[fredg]

I used Dmax("[Bid Date]","Estimating Guide") works great....btw..Dmax stands
for Domain Max

try using Dmax (which stands for Date Max)

I have a report showing Bid Information for various projects, including the
Field [Bid Date] which is formatted as Date/Time. In the footer of the report
I would like to show the most recent date from this field. I have tried to
use =max([Bid Date]) which returns #Error.

The problem with your using DMax (as written) is that it is checking
for the maximum date in the table, which may or may not be the maximum
date shown in the report, i.e. if you have filtered the report, the
maximum date in the report may be different than that in the table.