Good Morning,
I am trying to run a query based on a date. Under my "Action Items" Table there is a column labeled "Due Date" it is the data type "Date/Time" and ion the table shows up as "M/DD/YYYY". I have a query called "Overdue Action Items" I want this query to only pull the items that have a due date that has passed. What is the simplest way to do this?
I am trying to run a query based on a date. Under my "Action Items" Table there is a column labeled "Due Date" it is the data type "Date/Time" and ion the table shows up as "M/DD/YYYY". I have a query called "Overdue Action Items" I want this query to only pull the items that have a due date that has passed. What is the simplest way to do this?