I tried you example and get the error if I do something like this where shippingdate = '.vmindate'
try taking the ' ' off the code. Now as far as 7.1 I am in the same boat you are. How ever I went and got my own copy and start learning on my own. If you have not done so, do it so that when your company does switch your ready. There is enough of a learning curve that if you just get "thown in it" you may get lost. On 20 Sep 2005 at 10:11, Ramsour Mike wrote: > 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 > > Victor Timmons Tiz's Door Sales, Inc 425-258-2391
