Here is what is under the SQL code:
Code:
SELECT [Action Items].[Date Added], [Action Items].[Added By], [Action Items].Participants, [Action Items].[Origin of Issue], [Action Items].[Department Responsible], [Action Items].Line, [Action Items].Shift, [Action Items].Area, [Action Items].Equipment, [Action Items].Status, [Action Items].Priority, [Action Items].[Due Date], [Action Items].[Completion Date], [Action Items].[Assigned To], [Action Items].[Description of Issue/Problem], [Action Items].[Corrective Action], [Action Items].Comments, [Action Items].Field1, [Action Items].Field1.FileData, [Field1].[FileFlags] AS Expr1, [Action Items].Field1.FileName, [Field1].[FileTimeStamp] AS Expr2, [Action Items].Field1.FileType, [Field1].[FileURL] AS Expr3FROM [Action Items]
WHERE ((([Action Items].[Due Date])<=Date()) AND (([Action Items].[Completion Date])<>"(4) Completed"));
and it is a date/time data type. It looks like 7/12/2017