Re: Add different frequency days to dates
I don't know if it is possible to have it in the table. I thought if I can get a formula in the "default" to do the calculation then it is in the table.
Table is assetno, asset_type, cur_date, frequency, base_date. (insp_date)
base dates are different and frequency are also different.
i.e. base date 2021-07-12 freq. is 182 days until next inspection.
2020-11-15 freq 750 days.
So interval can't work because of the different frequency days.
Subject
Views
Written By
Posted
Re: Add different frequency days to dates
375
May 10, 2022 04:00AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.