how to get the next valid date?

Hi,

I have the following issue.

I have to get the 'mm/yyyy' part of date from one column and 'dd' part from another column and cobine the both to for the result. When I do this, the result could be an invalid date. In such case, I need to get the next valid date.

Ex.

Col1 : 02/10/2000      -- mm/yyyy   --> 02/2000   -- a
Col2 : 10/31/2000      -- dd        --> 31        -- b

Res : a oper b --> 02/31/2000

I want it to be either the previous or next valid date. In my case, result has to be either '02/29/2000' or '03/01/2000'. Anyone will do.

Is this possible to do in SQL qry? If so, how?

Thanks, Received on Fri Aug 31 2001 - 14:03:16 CDT