Access

摘要

Consider a query that has columns for DateDue, AmountDue, and DaysOver-due. DaysOverdue is a calculated field and can be used in expressions for other calculated fields. The formula for DaysOverdue is: DateDiff('d", [DateDue], DateO). DateDiff finds the difference between two dates and returns the result in the specified time interval, such as days, months, or years. DateO returns the current date and is like the TODAY function in Excel.