Jennifer, What are your date format and sequence? To see, type SHOW DATE at an R> prompt.
My first guess would be that some dates have been saved in the wrong century, that you are viewing dates with just 2 digits showing for the year, and that the wrong century dates appear to be out of order. If that is the problem, people here can show you how to update all dates that are wrong. Bill On Mon, Apr 28, 2008 at 1:27 PM, Roberts, Jennifer < [EMAIL PROTECTED]> wrote: > This electronic message contains information from The Ohio Masonic Home, > its operating subsidiaries or affiliates. The information may be > confidential, privileged or otherwise protected from disclosure. The > information is intended to be received solely by [email protected], for > use as designated in the message. If you are not the designated recipient, > you are instructed not to review, disclose, copy, distribute or otherwise > use of this transmission or its contents. If you have received this > transmission in error, please notify The Ohio Masonic Home immediately at > [EMAIL PROTECTED]; in addition, please delete your record of > transmission. Sending, receiving, downloading, displaying, printing material > that is harassing, fraudulent, offensive, intimidating, defamatory, or > otherwise unlawful or inappropriate is strictly prohibited by The Ohio > Masonic Home. > > > > ---------- Forwarded message ---------- > From: "Roberts, Jennifer" <[EMAIL PROTECTED]> > To: <[email protected]> > Date: Mon, 28 Apr 2008 13:27:56 -0400 > Subject: Illegal Column Specification > > Hello, > > I am trying to create a report where the data is being filtered with the > following code: > > PRINT hpreport WHERE discharge IS NULL + > > AND company <> '003' + > > AND nexthp < .vtoday + > > OR nexthp BETWEEN .vtoday AND (.vtoday + 7) + > > ORDER BY room ASC, nexthp ASC + > > However the order by does not work. I get an order by room number, but > then not by the nexthp which is a date field. I thought that I should put a > 'group by' in since I need to basically group by building a floor, and then > show the dates in ascending order on each building/floor. Every time I try > to put a group by clause in here it gives mt the illegal column > specification error. What am I doing wrong here? I'm sure I am overlooking > something really simple. J > > Thank you, > > Jennifer Roberts > > Business Applications Specialist > > Ohio Masonic Home > > This electronic message contains information from The Ohio Masonic Home, > its operating subsidiaries or affiliates. The information may be > confidential, privileged or otherwise protected from disclosure. The > information is intended to be received solely by [email protected], for use > as designated in the message. If you are not the designated recipient, you > are instructed not to review, disclose, copy, distribute or otherwise use of > this transmission or its contents. If you have received this transmission in > error, please notify The Ohio Masonic Home immediately at [EMAIL PROTECTED]; > in addition, please delete your record of transmission. Sending, receiving, > downloading, displaying, printing material that is harassing, fraudulent, > offensive, intimidating, defamatory, or otherwise unlawful or inappropriate > is strictly prohibited by The Ohio Masonic Home. > > > > >
