Enter a valid date for FORECAST_START_DATE. and for FORECAST_FINISH_DATE
Hi Team
While uploading file following error ‘Enter a valid date for FORECAST_START_DATE. and for FORECAST_FINISH_DATE’ is coming for custom webadi after EBS upgrade from 12.1.3 to 12.2.10
Below is the default value in formula type in webadi layout.
IF(AND([ACTUAL_START_DATE]="",[PV_FORECAST_START_DATE]<>""),TEXT(([PV_FORECAST_START_DATE]),"dd-mmm-yyyy"),IF([ACTUAL_START_DATE]<>"",TEXT(([ACTUAL_START_DATE]),"dd-mmm-yyyy"),IF([PLAN_START_DATE]<=TODAY(),TEXT((TODAY()),"dd-mmm-yyyy"),IF([PLAN_START_DATE]>TODAY(),TEXT(([PLAN_START_DATE]),"dd-mmm-yyyy")))))
Please help.
Thank you,
Nageswar