RE: [RBASE-L] - Where Clause for a Date Column, but I only want to search based on month...

2016-06-30 Thread Dan Goldberg
No prob. Enjoy all the nifty things you can do with Rbase. Dan Goldberg From: rbase-l@googlegroups.com [mailto:rbase-l@googlegroups.com] On Behalf Of asgkuschinsky Sent: Thursday, June 30, 2016 4:14 PM To: RBASE-L Subject: Re: [RBASE-L] - Where Clause for a Date Column, but I only want to

Re: [RBASE-L] - Where Clause for a Date Column, but I only want to search based on month...

2016-06-30 Thread asgkuschinsky
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

Re: [RBASE-L] - Where Clause for a Date Column, but I only want to search based on month...

2016-06-30 Thread A. Razzak Memon
At 06:47 PM 6/30/2016, asgkuschinsky wrote: 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

RE: [RBASE-L] - Where Clause for a Date Column, but I only want to search based on month...

2016-06-30 Thread Dan Goldberg
Where (imon(datecolumn)) = 6 Dan Goldberg From: rbase-l@googlegroups.com [mailto:rbase-l@googlegroups.com] 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