I have two columns, Date & Now. They are both formatted as General Date
10/10/2013 4:11:00 AM 10/10/2013 4:59:33 PM
9/5/2013 5:41:00 PM 10/10/2013 4:59:33 PM
I want to be able to query for [NOW] >24 hours from [Date]. A simple "Yes" "No" answer would suffice.
Any simple solution for an iif expression here?
Your help is greatly appreciated. I am sure that I must be overthinking this.