--- Begin Message ---
Here is my date format and sequence...
R>SHOW DATE
DATE format MM/DD/YYYY
DATE sequence MMDDYY
Century threshold YEAR is 30
Default CENTURY is 19
From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of Bill
Downall
Sent: Monday, April 28, 2008 2:03 PM
To: RBASE-L Mailing List
Subject: [RBASE-L] - Re: Illegal Column Specification
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.
--- End Message ---
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.
