>I am trying to create a query whereby the results will be given between 2 dates. My query is below. This does not work! My question would then be Is it possible to use the BETWEEN statement in an SQL?
>
>

>WITH thisform.pageframe1.page3.list3
>	.RowSourcetype = 3
>	.Rowsource = 'SELECT mainkey FROM pdmlog' + ;
>	             ' WHERE pdmlog.type="Change" and pdmlog.database="COST2"' + ;
>	             ' and BETWEEN(pdmlog.date,{^2003-04-01},{^2003-04-02})INTO CURSOR result'
>ENDWITH
>

>
>Many Thanks in Advance

Neil,

Sure. Like this

pdmlog.date BETWEEN '01/04/2003' AND '02/04/2003'