I am very new to Access and am trying to use the DateDiff function within a report based on a query. The query is a join of two tables using an ODBC connection. I want to subtract today's date from dates in a column of the report. Is this possible? Also I can not seem to get the syntax correct on the function. Here is what I tried. I created a text box and then in the properties, Control Source, I typed the following: = DateDiff("d",now,[Date_Due_Oper]). Date_Due_Oper is the name of the column that I want to pull the dates from.