• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 257
  • Last Modified:

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
0
zpotok
Asked:
zpotok
1 Solution
 
mbizupCommented:
Try this for your date field's criteria:

< Now() OR IS NULL
0
 
als315Commented:
DateDetermination: IIf(IsNull([MedicalCertExpireDate]) Or [MedicalCertExpireDate]<Now(),"None",[MedicalCertExpireDate])
0
 
zpotokAuthor Commented:
Thanks
0

Featured Post

Become an Android App Developer

Ready to kick start your career in 2018? Learn how to build an Android app in January’s Course of the Month and open the door to new opportunities.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now