G Guest Dec 12, 2005 #1 Using Access 2003, I want to calculate the number of days late for reports by adding the "Last Act" (Date) to the current date.
Using Access 2003, I want to calculate the number of days late for reports by adding the "Last Act" (Date) to the current date.
G Guest Dec 12, 2005 #2 Could you add an unrefrenced text box type this into the box =Date()-[Last Act] or =[Last Act]-Date() not sure which way it goes. Try it.
Could you add an unrefrenced text box type this into the box =Date()-[Last Act] or =[Last Act]-Date() not sure which way it goes. Try it.
S SusanV Dec 12, 2005 #4 Hi, You can use the DateDiff function for this: http://www.fabalou.com/Access/Modules/datediff.asp
