RE: I have the error:

--- "Bernstein, Rick" <rbernste@alarismed.com> > wrote: >To what value is the environment variable DBDATE set, >when you run this SQL through dbaccess? >If it is not set to "MDY2/", that could explain your error. That isn't a factor on our system. I am able to get dbaccess to recognize dates regardless of delimiter, 2 or 4 digit years, and even changing the zeroes to the letter O (both upper and lower case)! carlos == Maintainer of the procrastinator's FAQ. Well, maybe tomorrow I will be. _____________________________________________________________ Want a new web-based email account ? ---> http://www.firstlinux.net