Fill in blanks

[D B Lawson]

In a query, if a date field is blank, I want to put in the current date. I thought this might do:

WorkDate: If(IsNull([WDate])," Date()",[WDate])

but it but I'm getting an "Undefined If" message.

Is there anyway to put in a default date into a select query if the WDate field is empty?

 

[D B Lawson]

Got it:

WorkDate: IIf(IsNull([WDate]),(Date()),[WDate])