Date calculations

Littlebobo

I have created a report but need to create totals on the report to work out whether the goods were shipped on time and in full. The report itself is basically displaying information about goods shipped grouped by location by shipment no.

I thought that i would be able to do this by adding a total fields data item but clearly this is more complicated than this..I'd really appreciate some help or a push in the right direction as i'm really not sure

Sorry and thanks !

DenSter

What does displaying totals in a report have to do with date calculations?

Littlebobo

Sorry maybe im not making myself clear i want to create a figure that will give a no of days difference between one date and another ?

does that make sense !

DenSter

Nope that makes no sense at all, sorry

Littlebobo

Okay so something should be delivered on the 011209 but doesn't arrive until the 031209 making a difference of 2 days ..I want to know how to calculate that ?

DenSter

You can subtract two dates and put the results into an integer. I still don't understand what that has to do with your original post.

CobaltSS

Hi,

I think the "totals" in the original post was incorrectly used. Totals are applied after a section of information is displayed (like after a Location in an inventory report, before the next location, the total Qty of the inventory in the location is displayed).

Daniel is right though, you can create a field in the OnAfterGetItem of the DataItem on the report; the field should be an integer. Populate it with intNewField := Date1 - Date2. The integer value I believe will be in days. If you have DateTime datatypes, you can use a duration datatype as the result of the subtraction of the two DateTimes.

cheers,

Alex_Chow

integervariable := 031209D - 011209D

Littlebobo

Right think i am getting somewhere ( i know this is really easy to most of you but im learning so bear with me) ..anyway now i seem to get the information displaying correctly but since adding the intger i get a load of blank pages printing afterwards for no apparent reason, I have tried changing properties etc but nothing seems to get rid of them ???

Any idea what i can check to try and get rid of them ?

Thanks

LB

DenSter

Yes check with your senior and go over your report and let them tell you what you can do.