Skip to main content

Adding Custom Buttons to Oracle APEX Date Picker Footer (Set Start and End of Month)

In Oracle APEX, the built-in Date Picker is simple and functional — but sometimes, users need quick shortcuts for commonly used dates. For example, setting the first or last day of the current month with just one click can save time and reduce input errors.

In this post, we’ll enhance the Oracle APEX Date Picker by adding two custom buttons — “Set Month Start” and “Set Month End” — directly inside the date picker footer. Using a small piece of jQuery code, you can seamlessly integrate these buttons without modifying the native APEX components.

By the end of this guide, your Date Picker will not only look smarter but also provide a faster and more user-friendly experience. 

⚙️ This customization is created for learning purposes.

Paste the below code on execute when page loads (js)

apex.jQuery(document).on('focus', '#P20_START_DATE', function() {

  var intervalId = setInterval(function() {

    var $footer = apex.jQuery('.a-DatePicker-footer');

    if ($footer.length) {

      if (!$footer.find('.my-custom-btn').length) {

        $footer.append('<button class="a-Button t-Button--hot my-custom-btn">Set Month Start</button>');

        $footer.off('click', '.my-custom-btn').on('click', '.my-custom-btn', function() {

          var today = new Date();

          var monthStart = new Date(today.getFullYear(), today.getMonth(), 1);

          var dd = String(monthStart.getDate()).padStart(2, '0');

          var mm = String(monthStart.getMonth() + 1).padStart(2, '0'); 

          var yyyy = monthStart.getFullYear();

          var formattedDate = dd + '/' + mm + '/' + yyyy;

          apex.item('P20_START_DATE').setValue(formattedDate);

        });

      }

      if (!$footer.find('.my-custom-btn-end').length) {

        $footer.append('<button class="a-Button t-Button--hot my-custom-btn-end">Set Month End</button>');

        $footer.off('click', '.my-custom-btn-end').on('click', '.my-custom-btn-end', function() {

          var today = new Date();

          var monthEnd = new Date(today.getFullYear(), today.getMonth() + 1, 0);

          var dd = String(monthEnd.getDate()).padStart(2, '0');

          var mm = String(monthEnd.getMonth() + 1).padStart(2, '0');

          var yyyy = monthEnd.getFullYear();

          var formattedDate = dd + '/' + mm + '/' + yyyy;

          apex.item('P20_START_DATE').setValue(formattedDate);

        });

      }

    } else {

      clearInterval(intervalId);

    }

  }, 250);

});

Note: I'll Set P20_START_DATE format mask as DD/MM/YYYY

Demo_Application

Comments

Popular posts from this blog

APEX - Tip: Fix Floating Label Issue

Oracle APEX's Universal Theme provides a modern and clean user experience through features like floating (above) labels for page items.  These floating labels work seamlessly when users manually enter data, automatically moving the label above the field on focus or input.  However, a common UI issue appears when page item values are set Dynamically the label and the value overlap, resulting in a broken and confusing user interface. once the user focuses the affected item even once, the label immediately corrects itself and displays properly. When an issue is reported, several values are populated based on a single user input, causing the UI to appear misaligned and confusing for the end user. Here, I'll share a few tips to fix this issue. For example, employee details are populated based on the Employee name. In this case, the first True Action is used to set the values, and in the second True Action, paste the following code setTimeout(function () {   $("#P29_EMAIL,#P29_...

Oracle APEX UI Tip: Display Page Title Next to the APEX Logo

In most Oracle APEX applications, every page has a Page Title displayed at the top. While useful, this title occupies vertical space, especially in apps where screen real estate matters (dashboards, reports, dense forms). So the goal is simple: Show the page title near the APEX logo instead of consuming page content space. This keeps the UI clean, professional, and consistent across all pages. Instead of placing the page title inside the page body:         ✅ Fetch the current page title dynamically         ✅ Display it right after the APEX logo         ✅ Do it globally, so it works for every page All of this is achieved using:         ✅ Global Page (Page 0)         ✅ One Dynamic Action         ✅ PL/SQL + JavaScript Simple, effective, and reusable. 1️⃣ Create a Global Page Item On Page 0 (Global Page), create a hidden item:      P0_PAGE_TITLE This item wi...

Interactive Grid Tips (Part-1)

Selection Toolbar Events Validation Styling Advanced Selection 1 Get Selected Row Primary Key Return selected row PK values to a page item. Two approaches depending on APEX version. Selection APEX 24.2+ Before 24.x Copy // Initialization JavaScript Function function (options) { options.defaultGridViewOptions = { selectionStateItem: "P22_SELECTED_IDS" }; return options; } Copy var ig$ = apex.region( "EMP" ).call( "getViews" , "grid" ); var model = ig$.model; var selectedIds = []; ig$.view$.grid( "getSelectedRecords" ).forEach( function (rec) { selectedIds.push(model.getValue(rec, "EMPNO" )); }); $s ( "P22_SELECTED_IDS" , ...