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 woul
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 g
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 calcu
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
___
