Re: Date calculation gives strange format

}Date: Wed, 23 Apr 1997 15:56:14 +0100 }From: Richard Thomas <richardt@themusicstore.co.uk> }Subject: Re: Date calculation gives strange format }X-Informix-List-Id: <list.14161> } }>How about: }> }> select date(date('1/4/1997') + 1 units month) from uniq; } }Thanks for the super-quick answer (got the answer before the question }got back to me from the list!!). Tried it, and it works fine! Sorry to spoil the show, but it won't work on 31st May, 31st August, 31st October, 31st March, nor the 29th January (most years), 30th and 31st January (assuming that 1 month is added). Dealing with those dates is much harder. Yours, Jonathan Leffler (johnl@informix.com) #include <disclaimer.h>