Hi Folks:
I have one field in Apex that is a date field (:P4_PASTURE_START_DATE). I want to add a number to that date (the reason: an event will include a start date and the user will put how many days it will occur over. The saved data will be converted to a a date).
The Field that contains the number is: :P4_PASTURE_END_DATE. It is actually just a number field.
The problem I have is that when the :P4_PASTURE_START_DATE and :P4_PASTURE_END_DATE I get an ORA-01722: Invalid Number Error.
to_date(to_char(:P4_PASTURE_START_DATE + :P4_PASTURE_END_DATE, 'MM/DD/YYYY')),
TO_DATE(:P4_PASTURE_START_DATE +:P4_PASTURE_END_DATE),
I tried hard coding the end date as just a number and received the same error:
to_date(:P4_PASTURE_START_DATE + 5, 'MM/DD/YYYY'),
to_date(to_char(:P4_PASTURE_START_DATE + 5) 'MM/DD/YYYY'),
I'd appreciate any ideas/help in how to code this for a custom PL/SQL Insert (I am able to insert all the other fields ok, just not this one).
Summary:
I need to add :P4_PASTURE_START_DATE (date field) + :P4_PASTURE_END_DATE (number field) to add the extra days to the start date ( so Pasture_Start_Date is a date such as 09/14/2021 and the End date might be 5. I want to save the end_date as as the start date with 5 days added to it (so 09/19/2021).
Any help is appreciated ...
Matthew