var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: dmax with date criteria
How would I use the dmax function to find the maximum value of a field where the date is from the year 2004.
=DMax("[Freight]", "Orders", "[ShipDate] Like #2004#")
Is this correct?
I was sure on the rules regarding the "like" operator and dates
=DMax("[Freight]", "Orders", "Year([ShipDate])=2004")
I was unaware you can use functions inside of criteria like that!