Mike Are you changing the Date Format or Date Sequence between the time you set the text date variable and using <column> = .vmintext
Buddy -----Original Message----- From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of Ramsour Mike Sent: Tuesday, September 20, 2005 10:11 AM To: RBASE-L Mailing List 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. ================================================
