Hi Mike,
Try using SET VAR vmintext TEXT = (ctxt(.vmindate))
Bernie Lis
----- Original Message -----
From: "Ramsour Mike" <[EMAIL PROTECTED]>
To: "RBASE-L Mailing List" <[email protected]>
Sent: Tuesday, September 20, 2005 10:11 AM
Subject: [RBASE-L] - Invalid date value error
Good morning:
I frequently get an "Invalid date value" error in my programs. Based on
advice from the list, I typically create a date variable and then assign
the
value to a text variable.
For example:
SET VAR vmindate DATE = ( .#date - 1)
--
SET VAR vmintext TEXT = .vmindate
I then use the text equivalent of the variable in my program using
<column>
= .vmintext.
What is perplexing is that I can run a program and get the error message
and
then IMMEDIATELY rerun the program and it will run fine with no errors. I
have confirmed the value of the variables using the SHOW VAR command. My
database gets RELOADed daily and I run R:SCOPE against to verify the
database integrity.
Why is this happening? Is there a better way to deal with date values?
I am using R:Base 6.5++ (sorry, my company hasn't given me the money yet
to
upgrade to 7.1 -- drat!)
Please help before I go completely crazy!
Thanks
Mike Ramsour
c/o AK Steel
Voice 740-829-4340
--- RBASE-L
================================================
TO POST A MESSAGE TO ALL MEMBERS:
Send a plain text email to [email protected]
(Don't use any of these words as your Subject:
INTRO, SUBSCRIBE, UNSUBSCRIBE, SEARCH,
REMOVE, SUSPEND, RESUME, DIGEST, RESEND, HELP)
================================================
TO SEE MESSAGE POSTING GUIDELINES:
Send a plain text email to [email protected]
In the message SUBJECT, put just one word: INTRO
================================================
TO UNSUBSCRIBE:
Send a plain text email to [email protected]
In the message SUBJECT, put just one word: UNSUBSCRIBE
================================================
TO SEARCH ARCHIVES:
Send a plain text email to [email protected]
In the message SUBJECT, put just one word: SEARCH-n
(where n is the number of days). In the message body,
place any
text to search for.
================================================
