Query by date , not using conventional date format

[Guest_imported]

My table has a text field called Expiration Date which gets it's information from a form called frmMembership that has the Data Input Mask set to 99/9999;0;_ I need to find all records that are past due in otherwords if month is 02/2000 I need to find all records &lt;= 02/2000 any ideas how this might happen. Since date() is looking for mm/dd/yy as set on this computer.<br>
<br>
Thanks in Advance!

 

[jgarnick]

Change the date format in the query for the field you are referring to. Right click on the field in the query grid, click on properties, then type mm/yyyy on the format line. Then fill in your criteria &lt;=02/2000. Good luck! <p>jgarnick<br><a href=mailto:jgarnick@aol.com>jgarnick@aol.com</a><br><a href= > </a><br>