moopenguin32
Technical User
I am using Crystal Reports XI connecting to an Oracle database that houses help desk information. I am using DateDiff to calculate the difference in days between when a help desk ticket is opened and closed. Here is the formula I am using:
Then, I take this value to make a graph. However, in the graph, it shows the days open as 0.00, 1.00, 2.00 and so forth. I would like to show whole numbers such as 0, 1, 2, etc.
How can I format the numbers so they appear without decimals? Thanks in advance for your assistance.
"Remember, today is the tomorrow you worried about yesterday." - Dale Carnegie
Code:
DateDiff( "d",{HPD_Help_Desk.Reported Date},{HPD_Help_Desk.Last Resolved Date})
Then, I take this value to make a graph. However, in the graph, it shows the days open as 0.00, 1.00, 2.00 and so forth. I would like to show whole numbers such as 0, 1, 2, etc.
How can I format the numbers so they appear without decimals? Thanks in advance for your assistance.
"Remember, today is the tomorrow you worried about yesterday." - Dale Carnegie