Subtract one day from a date

[ulicki]

Hi,
I have created a view which calls a function (relevant line of code below):

optionsVested(grnt.grant_num, canc.CANC_DT, DECODE(grnt.sar_flag,2,1,0)) VESTED - Returns a number

The canc.CANC_DT field is a date field. I need to pass the day before. So if CANC_DT is 01/01/02, I need to pass 12/31/01.

Thank you,

 

[karluk]

Simply subtract 1 from CANC_DT.