How do I do this???

[szeiss]

Using Oracle 10g, I need to figure out starting from today's date, what phase will I be in in 6 months according to the schedule.

            Start       End
Phase 1                 1/31/2009
Phase 2     2/28/2010   6/16/2010
Phase 3     6/16/2010   12/31/2010
Phase 4     12/31/2010  5/10/2012
Phase 5     5/10/2012   5/10/2014

It's possible to have an empty date field.

Thanks,
Sherry

 

[jaxtell]

Take a look at the add_months function and BETWEEN keyword. I think you'll need to nvl any date field that could be empty.

-----------------------------------------
I cannot be bought. Find leasing information at

http://www.joshaxtell.com/