Returning integer from Date diference

nileshr18

Hi,
I want to subtract Enquiry Date from Order date and return the diference in integer
for Eg, Order Date=15/03/09 & Enquiry Date=10/03/09
Diference=Order Date-Enquiry Date.
Then the differnce is 5.

matttrax

So do it.

Result := Order_Date - Inquiry_Date;

Result will be an integer and will be the number of days between the two dates.