Is there a way to increment dates?
809712Nov 17 2010 — edited Nov 17 2010I have a table with a column listing the depart dates of certain holidays. I have a seperate table with a column stating the holidays duration.
What i need to do now is list the holidays start date and end dates (e.g depart date + holiday duration = end dates) Is there a way to do this? I cant think of a way as the dates and in DATE format and the holiday duration is in NUMBER.
Any suggestions would be appreciated.
Thanks in advance!
P.S - I need a query that will list the two columns (Start Date, Finish Date)
Edited by: Jay on 17-Nov-2010 05:02