Hello, lseptimiu@...!
You wrote to <IBObjects@yahoogroups.com> on Fri, 19 Aug 2005 02:12:49 -0700
(PDT):

l> Maybe this is a silly question, but I really need help. I need to
l> find the number of days that passed between two dates inside of a
l> procedure. I know one way, by decomposing the dates in zz-mm-yyyy
l> but, I try to find a simple way to do that... does anyone can help
l> me find the right solution?! is this the best solution?!
l> Looking forward....

Two ways

1) UDF
2) very, very simple:
FOR SELECT (FIRSTDATE-SECONDDATE) AS DAYSCOUNT
FROM TABLENAME
INTO :DAYSCOUNT
DO SUSPEND;



WBR,Dmitry Beloshistov AKA [-=BDS=-]