Querying date field in Access database?

[lowtide]

I need to query an Access db for all of<br>the rows that match a specific month and year only<br>in a smalldate field. What is the best way<br>to format the WHERE clause of the sql statement?<br>I would like to use the moth as a 2 digit number<br>and year as a 4 digit number.<br><br>I have tried &quot;WHERE datefield like 'mo%year%'&quot;<br>But it does not work.<br><br>Thanks<br>Lowtide

 

[NickBulka]

It's been a long time since I did anything with Access,&nbsp;&nbsp;but I seem to remember that dates needed to be delimited by #<br> <p>nick bulka<br><a href=mailto:nick@bulka.com>nick@bulka.com</a><br><a href= > </a><br>

 

[LuvASP]

Format function of Access will work on this one. <br>expr1: format(yourdatefield, &quot;mm&quot<br>In the criteria enter the month you're querying. 1 for Jan, 2 for Feb, etc.