I have been having trouble lately with getting an "Invalid -DATE- format" error in my programs. It is not consistent or predictable. The problem seems to involve the use of variables in my code. I set date variables in my code and then update, delete or insert rows into tables based on the dotted date variables. In one particular program, for instance, I create a temporary view with dotted date variables in the definition so that the actual view definition contains a date reference like '06/16/2002'. This has worked beautifully for weeks. Now today the only way I could get the program to run was to change the reference to the dotted variables to function variables by enclosing them in parens. i.e. instead of just using .vstarting I had to use (.vstarting).
I have gone over my code with a fine toothed comb. Sometimes the code works fine other times it croaks on the date format error. Yes, I have made absolutely sure that my date format is set correctly and consistently. I have stepped through my code, I have examined the variables to make sure there's nothing screwy about them. I get the error when I'm dealing with different tables, so it's not just restricted to one table which may indicate a data problem. I am using the latest official release of R:Base for Windows on a Windows 2000 system. Has anyone experienced a similar problem? If so what was the solution? Is it better to use variable references using the parens in the code -- (.varname) vs .varname -- or shouldn't it work by just using a regular dotted variable? This is driving me crazy not to mention screwing up the data. Please, suggestions anyone? Thanks Mike Ramsour ================================================ TO SEE MESSAGE POSTING GUIDELINES: Send a plain text email to [EMAIL PROTECTED] In the message body, put just two words: INTRO rbase-l ================================================ TO UNSUBSCRIBE: send a plain text email to [EMAIL PROTECTED] In the message body, put just two words: UNSUBSCRIBE rbase-l ================================================ TO SEARCH ARCHIVES: http://www.mail-archive.com/rbase-l%40sonetmail.com/
