Friday, 7 August 2015

DYNAMIC DATE RANGE IN APEX DATEPICKER

Using this method you can set the range of selectable dates by entering a Minimum and Maximum Date value  dynamically “real-time”.

Step 1: Create a Page Item (Example: “P101_DATE”).

Step 2: Go to Settings -> Minimum Date 

     In Minimum Date valid condition has to be specified.
      Minimum Date Conditions are (..+3d,+2d,+1d,+0d,-1d,-2d,-3d..)
+0d   => It will display Both SYSDATE as well as all the future following the sysdate.
-10d    => It will display 10 days, which are below the sysdate (Sysdate is not accounted).

Example 1: (Minimum Date Condition)



OUTPUT:




















Example 2:





















 OUTPUT:






2 comments:

  1. Regards
    Sridevi Koduru (Senior Oracle Apps Trainer Oracleappstechnical.com)
    LinkedIn profile - https://in.linkedin.com/in/sridevi-koduru-9b876a8b
    Please Contact for One to One Online Training on Oracle Apps Technical, Financials, SCM, SQL, PL/SQL, D2K at training@oracleappstechnical.com | +91 - 9581017828.

    ReplyDelete
  2. It's interesting to read blog about punchout cxml.
    Punchout CXML

    ReplyDelete