Writing Code
 Crystal Reports Forum : Crystal Reports for Visual Studio 2005 and Newer : Writing Code
Message Icon Topic: Aged Report Post Reply Post New Topic
Author Message
bec9196
Newbie
Newbie
Avatar

Joined: 29 Jan 2009
Location: United States
Online Status: Offline
Posts: 2
Quote bec9196 Replybullet Topic: Aged Report
    Posted: 16 Jun 2009 at 10:46am
Hi.  I am trying to create a formula that will allow me to calculate how long a request has been in the system based on a certain milestone.  I have the formula for the milestone and it seems to work. 
 
My problem is that I can not figure out how to make the aged formula (see what I have below).  The error i receive says that "the remaining text does not appear to be part of the formula and the date after the comma in the first row is highlighted.  I have taken tried taking out the comma and then I get an error stating that says  "the remaining text does not appear to be part of the formula"
 
HELP PLEASE!
 
 
{@Milestone} = "Aged 0 to 30 days",
 ({requests.rpt_date} - 30) to CurrentDate,
 
 
Becca
IP IP Logged
Post Reply Post New Topic
Printable version Printable version

Forum Jump
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot delete your posts in this forum
You cannot edit your posts in this forum
You cannot create polls in this forum
You cannot vote in polls in this forum



This page was generated in 0.012 seconds.