Select * from myDATA
where #form.dateFIELD# LIKE '#monthsel#-%-#dateformat(now(), "yyyy")#'
you may need to play with the year, too as you are with the month, if you want sql to know if you want june 2003 or june 2004; sometimes its easier & faster to use multiple columns for each part of the date (month, day, year)
joe velez
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
