Hi
I am not sure if this has already been asked but I'm newbie to Microsoft access but I'm trying to figure out a way to make a query on a table to see when a date completed has exceeded 180 days from last completed. I have tried different formulas but not getting the results I want I have tried <=date()-180 and what I get is every date prior to the current date. I only want to know is when a date is older than 6 months or 180 days from todays date. I can do this in Excel I know but I'm trying to migrate and learn Microsoft access for future endeavors.