how to use commands for dates in a data environment ?

:cool:
hi friends,

i'm making a software that manages customers of a clinik (i'm using access database).

while using the data environment, i have encountered difficulties to use sql instructions that allows the data environment to display ONLY data matching with the current month. please i invoque the deep of your knowledge to help me.

michel,


"Select * From (your data Sheet) WHERE Date Between #" & Text1.Text & "# AND #" & Text2.Text & "# order by date "