Ah, tokenize the input, take the month and year pieces and query for month and year with a direct dbms Works
Thank you. On Jan 18, 2010, at 1:41 PM, Ben Johansen wrote: > Depends on database, but let's say for MySql > you could do > Select * from table where month(datefield) = 3 > and you would get only the March dates > > On Jan 18, 2010, at 1:35 PM, Roland Dumas wrote: > >> >> Given: table with event records. One column is a date field. >> >> Question: how do I request a date and get back only records in the same >> calendar month as the requested date? >> >> Ex: I put in 05/06/2010 and get back a set of records that are all 05/XX/2010 >> >> ________________________________________________________________________ >> TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf >> >> > > Ben Johansen > http://www.webspinr.com > [email protected] > Phone: 360-597-3372 > Mobile: 360-600-7775 > > > ________________________________________________________________________ > TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf > ________________________________________________________________________ TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf
