I have a table called "Monthly Activity Report" with a field called "Campaign End Day Desc". I want to use the MIN function to return the minimum of either the field value or a hard coded date. See below:

Min([Monthly activity report]![Campaign End Day Desc], #10/31/03#)

I get the following error: The expression you entered has a function containing the wrong number or arguments.

Can you even use the MIN function in this way?