Walker, Buddy wrote:
James Assuming your col is a date field then you would have to do something like this:
sel schedule#,audit_date from audit whe (imon(audit_date)) = 02 and (iyr(audit_date)) = 2006
You don't have to change the date format if all you are wanting to do is show the month and year.
sel schedule#,(CTXT(FORMAT(audit_date,'mmm+ yyyy'))) from audit whe (imon(audit_date)) = 02 and (iyr(audit_date)) = 2006
Buddy
-----Original Message----- From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of James Hageman Sent: Friday, February 18, 2005 2: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)
