1. Get rid of all advertisements and get unlimited access to documents by upgrading to Premium Membership. Upgrade to Premium Now and also get a Premium Badge!

How to add validation in datepicker, apex5.0

Discussion in 'Oracle Application Express (APEX)' started by akika, Mar 27, 2017.

  1. akika

    akika Active Member

    Messages:
    27
    Likes Received:
    0
    Trophy Points:
    80
    Location:
    New Delhi
    Hi,
    I have create a form in apex5.0 which contains a datepicker for a field payment_date.. i want to add a validation &/ dynamic action on that field so that user can select only today's date from it... other dates should be disabled or when user click on other date an error msg displayed...
    Any idea.. How to do that?
     
    Last edited: Apr 4, 2017
  2. Steven S.

    Steven S. Premium Member

    Messages:
    9
    Likes Received:
    1
    Trophy Points:
    20
    Location:
    USA
    Why select a date? Create a display only page item and set the default value to sysdate which will be set each time the page loads. The user submits the payment and sysdate is written to a table as the transaction date/time. I would make sure every time the page is accessed the page cache is cleared first.

    For that matter just create a trigger so when the payment is inserted a timestamp is inserted by the trigger.