If dateA > (isNull(DateB, ..., ..) Need help!

[sp00k]

[FONT=&quot]Basically I have it so, two dates can be entered on the form, the earliest date shows up on the last four digits of the project number(the later date does not)

I ran into a problem when rcDateSiteAwarded is null right now I have:

=IIf([rcQuoteSubmitted]<[rcDateSiteAwarded], .... so on, Works fine

I tried [/FONT][FONT=&quot]=IIf([rcQuoteSubmitted]< iif(isNull([rcDateSiteAwarded], rcDateSiteAwarded = #1/1/3000#, rcDateSiteAwarded)), .....rest of my code, doesn't work

but not seeming to work. Any ideas?
[/FONT]

 

[MSAccessRookie]

[FONT=&quot]Basically I have it so, two dates can be entered on the form, the earliest date shows up on the last four digits of the project number(the later date does not)[/FONT]

[FONT=&quot]I ran into a problem when rcDateSiteAwarded is null right now I have:[/FONT]

[FONT=&quot]=IIf([rcQuoteSubmitted]<[rcDateSiteAwarded],"Q"+ .... so on[/FONT]

[FONT=&quot]I tried [/FONT][FONT=&quot]=IIf([rcQuoteSubmitted]< iif(isNull([rcDateSiteAwarded],"Q"+ ))[/FONT]

[FONT=&quot]but not seeming to work. Any ideas?[/FONT]

Try including a test for [rcDateSiteAwarded] for Null first

IIf((([rcDateSiteAwarded] Is Null) Or ([rcQuoteSubmitted] < [rcDateSiteAwarded])), 
    [rcQuoteSubmitted], 
    [rcDateSiteAwarded])

 

[sp00k]

thanks! working perfectly...at least for now