UtterAccess.com
X   Site Message
(Message will auto close in 2 seconds)

Welcome Guest ( Log In | Register )

 
 Reply to this topicStart new topic
> Days Open in Report    
 
   
epione
post Oct 16 2006, 11:13 AM
Post #1

UtterAccess Member
Posts: 28
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?
Go to the top of the page
 
+
bredmell
post Oct 16 2006, 11:30 AM
Post #2

UtterAccess Veteran
Posts: 306
From: Massachusetts
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
Go to the top of the page
 
+
epione
post Oct 24 2006, 11:56 AM
Post #3

UtterAccess Member
Posts: 28
Great ... Worked like a charm.
Go to the top of the page
 
+
bredmell
post Oct 24 2006, 12:14 PM
Post #4

UtterAccess Veteran
Posts: 306
From: Massachusetts
Happy to be of service.

Bruce

(IMG:http://www.utteraccess.com/forum/style_emoticons/default/thumbup.gif)
Go to the top of the page
 
+
« Next Oldest · Access Reports · Next Newest »
 

Thank you for your support! Reply to this topicStart new topic

Jump To Forum:
 

Display Mode: Standard · Switch to: Linear+ · Switch to: Outline

Track this topic · Email this topic · Print this topic · Subscribe to this forum

RSS Go to Top  ·  Lo-Fi Version Time is now: 22nd May 2013 - 08:09 AM