Hi All,
I have 5 items (used as filters on an IR) on my page.
Date Pickers - 2; List Managers - 2 ; Shuttle - 1.
All of these are Optional fields.
But the I have a requirement to default the Date Pickers to display SYSDATE when the User first enters the page.
I used the Default option in the date picker Item but since it's not a required field and could be NULL, the default option is loading the value with SYSDATE when every date picker item is NULL.
I tried using Dynamic actions to set the value to SYSDATE but no luck. I also have a Clear Cache button on this page which does not clear the reset the date picker items but always resets it to SYSDATE.
While everything is functioning as the Default settings should. Could anyone throw some light on how to achieve this?
Versions
DB-12c ; Apex - 5.1
Thank you all in Advance,
Daniel