Query date but not date......

[gnibbles]

Im trying to do a query of dates but they arent classified as dates so the Between function for criteria doesnt work and if I try and use >= function and in the criteria use or <= it comes with dates outside the margin I want. If someone can help me I would appreciate it. Thanks.

 

[SIG357]

Have you tried using the CDate Function to convert to a date format first?  That should allow you to use the Between...And function.  Hope that helps.

 

[unicorn11]

well create a macro in that use the vb cdate function and then convert both the valuse into date and then convert it <br> <p>Unicorn11<br><a href=mailto:webmaster@tripmedia.com>webmaster@tripmedia.com</a><br><a href= > </a><br>Hi there it all likeminded fellows!!!!!!

 

[gnibbles]

but all is there is the month, I wish it was so easy as to convert it. And then there is another separate field called year that I have to break it down to as well andit comes back with all years.