CRYSTAL REPORT CONVERTION DATE

[mongos30]

I'm a new usuer of CRYSTAL REPORT and need some help. I created a report where I have listed my promise DT and billed DT for a particular month. Now I need to know the difference amount of days differences between this two columns. I know how to do it if both columns are in the same month but I'm having problems in make it work with differente month. I need to make it run with both same month and differente month at the sametime.
Please help!
Thanks
MARCIA

 

[kscheeler]

Since you're probably going to display one or the other date on the report, create 3 formula's.

Formula Name: Promise Date
NumberToDate({oeordlin_sql.promise_dt})

Formula Name: Billed Date
NumberToDate({oeordlin_sql.promise_dt})

Formula: Difference
{@Billed Date} - {@Promise Date}


Kevin Scheeler

 

[kscheeler]

Sorry, slight change on the Billed Date formula

Formula Name: Billed Date
NumberToDate({oeordlin_sql.billed_dt})


Kevin Scheeler