If your user picks a date (vdate) from a variable calendar object, you could do this:
set var vsearch text = ((tmon(.vdate)) & (ctxt(iyr4(.vdate)))) And put this in your where clause: Where audit_date contains .vsearch -----Original Message----- From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of James Hageman Sent: Friday, February 18, 2005 6:43 PM To: RBG7-L Mailing List Subject: [RBG7-L] - RE: Guess I need a SET DATE refresher That was a typo in email. With 'february 2006' I still get no rows back, even though there are 3 rows present. What I am trying to do is have the user CHOOSE a month and then rbase pulls every row that has that month in it. I've tried many different style of SET DATE and still cannot pull out the data. claudinerobbins wrote: > If you actually typed 'febuary 2006' then type 'february 2006' and see what > you get... > > -----Original Message----- > From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of James Hageman > Sent: Friday, February 18, 2005 1:30 PM > To: RBG7-L Mailing List > Subject: [RBG7-L] - Guess I need a SET DATE refresher > > I set the date: > > R>set date 'mmm+ yyyy' > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ > > Here's my data: > > R>select schedule#,audit_date from audit > schedule# audit_date > ---------- -------------- > 252 May 2005 > 203 November 2004 > 185 March 2005 > 253 February 2006 > 254 February 2006 > 255 February 2006 > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ > > I try a select with a WHERE: > > R>select schedule#,audit_date from audit where audit_date = 'febuary 2006' > <WARNING> No rows exist or satisfy the specified clause. (2059) > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ > > I thought I should get the last 3 rows of data. > > help! > > (btw using 7.1.79.30214)
