Re: Leap Year

> > > At the stroke of midnight all our programs turned into pumkins. Is any one > aware of a problem with datetime or date veriables. (ERROR:1267). If so do > you know of a work-around. > Do you have code which tries to add a year to a date? select today + 1 units year from systables where tabid = 1 # ^ # 1267: The result of a datetime computation is out of range. # Same thing will happen with 12 units month. It won't happen with 365 units day. cheers j. _____________________________________________________________________________ Jack Parker - Hewlett Packard, DMD/IS Boise, Idaho, USA jparker@hpbs3645.boi.hp.com _____________________________________________________________________________ If anything can go wrong, fix it. To hell with Murphy. _____________________________________________________________________________ Any opinions expressed herein are my own and not those of my employers. _____________________________________________________________________________