[Lazarus] Microsft Access Date Select statment

[Jean SUZINEAU]

Le 24/03/2023 à 21:48, Larry Dalton via lazarus a écrit :
> Where Trans_date between beginning_date and ending_date;'

May be it would be better  with params ?

"Where Trans_date between :beginning_date and :ending_date;"

and then supposing  your TSQLQuery is declared as sqlq :

   sqlq.Params['beginning_date'].asDate:= EncodeDate( 2023, 01, 01);