Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

bring today's date into a report

Status
Not open for further replies.

jschill2628

Programmer
Nov 3, 2009
156
US
Is there any way to bring in today's date into a Crhstal report. What I would like to do is have the user run the report for an incident, the only problem with it is that the incidnet has not been closed out yet. The user would like to see how many day's it has been open (from the time it was claimed to today) I am just not sure how to classify or bring in todays date
 

Crystal provides the built in functions "currentdate" and "currentdatetime" for this type of requirement. In your case it would be:

datediff("d",{IncidentOpenDate},currentdate)



 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top