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)
