A couple of things to think about: The date format is a setting in the database, so if you connect to the database w/ the owner password and change the date settings, other users will get the new settings. One other thing to consider is if you are importing and exporting data, the settings may get changed from your load file.
Troy Sosamon ===== Original Message from [EMAIL PROTECTED] at 6/24/02 8:12 am >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/ ================================================ 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/
