--- tags: feature request, default value, date handling --- # Dynamic "Today" Default Value for Date Columns ###### Category: Feature Request ###### User: perguth ###### Source: [GitHub Issue #2754](https://github.com/centerofci/mathesar/issues/2754) ## Feedback Content >Problem >When selecting today as the default value for a column it sets the default to the current days date. > >Proposed solution >When selecting a default value for a column it would be helpful to keep today as meaning "always the date on which the new record will be created" (default CURRENT_DATE in SQL) instead of translating it into the concrete date of today. ## Context (Optional) The user is suggesting an improvement in the handling of date columns in Mathesar. They propose that when "today" is set as the default value for a date column, it should dynamically use the current date whenever a new record is created, rather than being fixed to the date when the default value was set. ## Related GitHub Issue(s) - [Related Discussion](https://github.com/centerofci/mathesar/discussions/2272) ## Actions - [ ] No action required - [ ] Needs to be addressed - [ ] Further action needed - [X] Roadmap suggestion