Line Chart for Start Date and End Date CR8.5

[vimblick]

Hi
I am trying to create a line chart showing Months between Start Date and End Date for a project and using todays date as the data.Therefore showing how far the project has progressed.
Hope someone can help.
Thanks

 

[Madawc]

Try something like

DateDiff("d", StartDate, EndDate)

Get the printed report looking OK, before attemting to insert a chart.

In your selection statement (Report > Selection Formula > Records), you'd probably want to say not isnull(EndDate), to exclude projects that have not yet ended.

I am assuming the two dates are in the same record. If not it is more complex, probably involving grouping for project code.

Madawc Williams (East Anglia, UK). Using Windows XP & Crystal 10

 

[lbass]

You might want to try a formula like:

if isnull({table.enddate}) then
datediff("d",{table.startdate},currentdate) else
datediff("d",{table.startdate},{table.enddate})

-LB