How can i know how many day passed betwen 2 dates

[AnacondaPower]

How can i know how many day passed betwen 2 dates.

i'm using interbase sql and i need that.

 

[svanels]

The basic would be:

day1 - day2

look also at: thread756-144302

another way is to put in a stored procedure which runs the query and results the number
S. van Els
SAvanEls@cq-link.sr

 

[HitokiriBattousai]

var
currentdate, pastdate : Tdate;
result : variant;
begin
result := strtodate(currentdate) - strtodate(pastdate);
formatDateTime('d', result);
end;