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)
