No prob. Enjoy all the nifty things you can do with Rbase. Dan Goldberg
From: [email protected] [mailto:[email protected]] 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 search based on month... 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]<mailto:[email protected]>. 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.
