select .. between.. 1

[miglou]

Hello,
i have this
fdt="09-Jul-02"
sdt="10-Jul-02"
strSQL="select name from employee where bd between " & fdt & " and " & sdt

whats the problem here??its because between.... or problems with bad using strings????
T.Y.

 

[ETID]

maybe this?

strSQL=&quot;select name from employee where bd >= &quot; & fdt & &quot; and <= &quot; & sdt

 

[LittleSmudge]

Actually, JET needs telling that there are dates that are coming to it and thet it should treat them as dates.

So use

strSQL = &quot;SELECT name FROM employee WHERE bd BETWEEN #&quot; & fdt & &quot;# AND #&quot; & sdt & &quot;#;&quot;


( If you always type SQL key words in CAPS then you'll find it a lot easier to read afterwards. )



QED.

G LS

 

[miglou]

Thanks
LittleSmudge's tip worked...
good luck