Several ways:
1. Get the DB to do the work by either
1. Use the methods that the DB has to split date
2. Or put the month and year in the DB as separate fields
2. Use Witango to split the date and calculate the first and last days of
the month, put both of the dates you calculate into your search and find the
events between the two dates
On Mon, Jan 18, 2010 at 4:35 PM, Roland Dumas <radu...@mac.com> 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
>
>
________________________________________________________________________
TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf
