Yes, that did it! Thank you, Dan.
I had tried several variations, some including IMON, but I think I over complicated it or misunderstood how to use it. I was under the impression I had to have an exact date inside the ( ) but apparently I did not. Thanks again. On Thursday, June 30, 2016 at 3:55:30 PM UTC-7, dang wrote: > > Where (imon(datecolumn)) = 6 > > > > Dan Goldberg > > > > *From:* [email protected] <javascript:> [mailto: > [email protected] <javascript:>] *On Behalf Of *asgkuschinsky > *Sent:* Thursday, June 30, 2016 3:48 PM > *To:* RBASE-L > *Subject:* [RBASE-L] - Where Clause for a Date Column, but I only want to > search based on month... > > > > Hello, > > I am trying to set up a Where clause that searches a Date column > (MM/DD/YY) but I only want to search based off of the month. > > For example, I want to search all dates in January regardless of the day > or year. > > I've tried several variations, both based on what I know and what I found > online, but I either get a syntax error or a date value error...Any > thoughts? > > Thanks. > > -- > You received this message because you are subscribed to the Google Groups > "RBASE-L" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to [email protected] <javascript:>. > For more options, visit https://groups.google.com/d/optout. > -- You received this message because you are subscribed to the Google Groups "RBASE-L" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. For more options, visit https://groups.google.com/d/optout.
