🚀 go-pugleaf

Ken Mayer wrote:
> 
> Andrea Starz wrote:
> >
> > Ken Mayer wrote:
> > >
> > > Andrea Starz wrote:
> > > > N.B.: Date are in format dd/mm/yy, is important?
> > >
> > > Yes. Try MM/DD/YYYY to be sure ... (although MM/DD/YY should work).
> 
> > Ok modified, not work and same error.
> >
> 
> My fault -- I didn't read the SQL as thoroughly as I ought -- dates must
> be strings -- change the {} to '' (single quotes ... or double if you
> are using single quotes for the whole string).
> 
> --
> Ken[1]@Borland
> <Please follow-up to newsgroup; do not reply to email>

Ok it works ! But.....
another problem: i have a date setting to dd/mm/yy and not mm/dd/yy and
this is a problem to remember in query designer.

Note: if I substitute a date expression in BETWEEN with two variables of
data type dd/mm/yy it works correctly. Why?
Ex.:
d1={01/12/97}
d2={31/12/97}
SELECT OL_AGG, COUNT(  DISTINCT COM_AGG )
 FROM "C:\APPL\ACOL\aggiorna.dbf" Aggiorna
 WHERE (DATA_AGG  BETWEEN  :d1  AND :d2)
 GROUP BY OL_AGG
 ORDER BY OL_AGG

Thanks

Andrea