Easy expression question

[brownk]

Hello everyone! Im trying to get a date to field to return either the date (which i have working) or to say "Unknown". When employees enter data into a loan program they will put in a date. If no date is entered, i.e its an unknown date, the database defaults to "1/1/1900". I am trying to get it to say "Unknown" rather than "1/1/1900". This is my code so far, keep in mind it is already successfully displaying the date as i want it, but its still displaying "January" for the "1/1/1900" dates.



Closing Date: Format([Date],"mmmm") & IIf([Date]=1/1/1900," Unknown ")

Can anyone tell me what im doing wrong?

Thanks

[RayMilhon]

Try this: IIF([DATE]=#1/1/1900#,"Unknown",Format([Date],"mmmm"))


Also I would consider changing the field name [Date] to something more descriptive like DueDate or OpenDate