epione
Oct 16 2006, 11:13 AM
Quick question that may involve a not so quick answer. Basically what i'm trying to do is create a report that says how many days an issue has been "open" in a open issues log at work. I know how to filter for open issues and the like, but what i don't know how to do, nor do i even know if it can be done, is make a colomn in a report say how many days an issue has been open. I'm assuming it would involve subtracting the created date from the current date and the converting it to a number. I have no idea how i would go about doing this. Can anyone help?
bredmell
Oct 16 2006, 11:30 AM
You're correct in your assumption that you would subtract the created date from the current date but there is no need to convert to a number. Simply create an unbound text box on your report and set it's Control Source to:
=Date()-[NameOfYourDateField]
HTH
Bruce
epione
Oct 24 2006, 11:56 AM
Great ... Worked like a charm.