Skip to Main Content
Feature Request FR-3855
Product Area Page Components
Status CLOSED

21 Voters

Current Date as Default in The Date Field

sikandar.awan Public · Jun 22 2024

Idea Summary
I was looking for default today date in the date field/picker as everytime we have to go to default and enter an expression.

Use Case
Normally there is a date column on every page like invoice_date so my required is there should be a check box or any other options so instead of writing sysdate as default should show current date then if user wants to change he/she can change. As Oracle APEX is low code then beter to avoid entering manually sysdate to show current date.

Preferred Solution (Optional)
If a check box is given like Default Current Date Y/N should serve the purpose.

We reviewed this idea carefully, and while it was interesting, we concluded that due to all the internal implications we need to take into account, it is unlikely to make its way into APEX.

Comments

Comments

  • mehboobgulzar45 OP 1 years ago

    yes

  • abrarji OP 1 years ago

    Yes it will be better

  • zahidse OP 1 years ago

    Yes, this will take APEX more towards it's tagline of low code.

  • rizwanshahdba OP 1 years ago

    Nice addition with the ‘Default Current Date’.

  • haseeb.tnr OP 1 years ago

    Yes it will be better

  • rana_ocp79 OP 1 years ago

    Should add default date option.

  • m.arif.maqsood OP 1 years ago

    Yes, it will be better but most important sum function in interactive grid Should be easy it's too complicated using java.

  • faisal760797 OP 1 years ago

    Yes it should be there.
    Also a built-in option for aggregating the Interactive grid should be added instead of writing lengthy and complex JavaScripts to calculate totals of Interactive grids.

  • awaisanwar23 OP 1 years ago

    Yes, It should have to be there.

  • nasimhaiderpk2 OP 1 years ago

    Nice addition

  • fac586 OP 1 years ago

    If a check box is given like Default Current Date Y/N should serve the purpose.

    Easier said than done.

    What is “current date”?

    • User's local date/time
    • Database server date/time
    • Organisation's head office date/time
    • UTC

    What about data type?

    • DATE
    • TIMESTAMP
    • TIMESTAMP WITH TIME ZONE
    • TIMESTAMP WITH LOCAL TIME ZONE

    Granularity?

    • Day
    • Minute
    • Second
    • Sub-second
  • sikandar.awan OP 1 years ago

    @fac586 Hi, It is very simple that if currently I need to show today date then I will go to default and will selection expression and will type sysdate then when I will open page it will show today's date. Now you can better know if I used just sysdate what it is considering from all the above options you shared. Requirement is simple instead of each time coding sysdate as default value better allow it as default or using a check box. thanks

  • shahbazshahbaz106 OP 1 years ago

    Yes, It must be

  • mohsinali_dba OP 1 years ago

    I would like to endorse it

  • vincent morneau Admin OP 1 years ago

    Hi all. The APEX team discussed this idea today and tends to agree with @fac586. A declarative way to determine default date and time could be nebulous pretty quickly. The default date is currently possible through the default value attribute.