We help IT Professionals succeed at work.

Date Field Conditional Formatting - revisited

Follow up to:

http://www.experts-exchange.com/Microsoft/Development/MS_Access/Q_27627895.html

DateDetermination: IIf(IsNull([MedicalCertExpireDate]),"None",[MedicalCertExpireDate])

Works fine (showing all records with dates and displaying 'None' if no date).
I actually need to show Records with date <Now() and those with no date as 'None'.  I added this to criteria which filtered ok but then I lost those records in which had no date 'None'.

Thanks
Comment
Watch Question

SILVER EXPERT
Most Valuable Expert 2012
Top Expert 2013
Commented:
Try this for your date field's criteria:

< Now() OR IS NULL
BRONZE EXPERT

Commented:
DateDetermination: IIf(IsNull([MedicalCertExpireDate]) Or [MedicalCertExpireDate]<Now(),"None",[MedicalCertExpireDate])

Author

Commented:
Thanks

Explore More ContentExplore courses, solutions, and other research materials related to this topic.