Comparing Date values that are not formatted the same and null

[cliff.clayman]

I have two date fields that I am trying to compare to see if they match. If they do not match, I want my query to display them. I have having problems formatting both fields to be the same date format and checking them for null values. Here is what I tried to do and I get an error stating that 'The expression you entered has a function containing the wrong number of arguments



<>IIF(IsNull(Format(CDate([Table1].[DateClosed]),"mm/dd/yyyy"),"N/A",[Table1].[DateClosed])

[ssanfu]

Well, the first problem is a missing closing parenthesis for the format function

<>IIF(IsNull(Format(CDate([Table1].[DateClosed]),"mm/dd/yyyy")),"N/A",[Table1].[DateClosed])

I don't think the expression will work because you cannot refer to a field like you have.
If this is on a form, maybe try

<>IIF(IsNull(Format(CDate([DateClosed]),"mm/dd/yyyy")),"N/A",[DateClosed])

Don't know what you are trying to do, so can't give you a better answer...