Using the Date() function

[Grey Whipple]

ACCESS 2003
I am creating a report that has two date fields: HireDate and EndDate.

The EndDate field in some records has a value, but most of them are empty (null). Where null, I want to insert the Current Date from whence I can determine how long a person has worked.

I am trying to use an IIF function, but can't get the syntax correct:

IIF (expression, true, false)

e.g. =IIF([EndDate]=null,=Date(),[EndDate])

I also notice that the =Now() in the page footer works just fine, but if I try to use =Date(), I always get a drop-down box requiring an Input Parameter for Date. Why?

Any help will be appreciated.
Grey

 

[RuralGuy]

Nothing is *ever* = to Null, including Null so try the IsNull() function.

 

[rainman89]

=IIF(isnull([EndDate]),Date(),[EndDate])

 

[Rich]

If you are getting a prompt for Date() then you have a missing reference