Manage Table: Items: Date
## Overview
In the "[Editor](/en/manual/table-management-editor)", you can use the "Date" items from "DateA" to "DateZ." The "Date" item can be used as input item where you can enter the date and time using free text or a calendar.
## Limitations
1. In the "Community Edition", you cannot place more than 27 "Date" items.
1. In "Pleasanter.net", you cannot place more than 27 "Date" items.
1. You cannot enter dates and times outside the range of 1900/1/1 to 2099/12/31 23:59:59.
1. When entering dates and times from the calendar, you cannot select years outside the range of 1950 to 2050.
1. In an Azure SQL Database environment, the date and time are saved in UTC. If you access the database directly from another application, you must convert it to JST before using it.
1. The first-generation user interface is excluded from the date/time input UI library that was changed in version 1.4.18.0, and changes to the UseOldDatepicker parameter are also invalid.
## Prerequisites
1. "Site Administration Permission" is required to configure settings.
## Advanced Settings
For advanced settings, refer to "[Input Column Advanced Settings](/en/manual/table-management-column-settings)".

|Setting item name|Default value|Description|
|---|---|---|
|Name displayed|DateA - DateZ|"[Name Displayed](/en/manual/table-management-label-text)" is [read only](/en/manual/table-management-readonly). It cannot be made editable.|
|Text alignment|Left alignment|Set the "[Text Alignment](/en/manual/table-management-textalign)"|
|Style|Normal|Set the "[Style](/en/manual/table-management-style)"|
|Required|Unchecked|Set the "[Required](/en/manual/table-management-required)"|
|Allow bulk update|Unchecked|Set the "[Allow Bulk Update](/en/manual/table-management-bulk-update)"|
|Duplication prohibited|Unchecked|Set the "「Duplication Prohibited」"|
|Copy with default values|Unchecked|Set the "[Copy with Default Values](/en/manual/table-management-copy-by-default)"|
|Read only|Unchecked|Set the "[Read Only](/en/manual/table-management-readonly)"|
|Editor format|Date|Sete the "[Editor Format](/en/manual/table-management-editor-format)"|
|Default value|(Blank)|Set the "[Default Value](/en/manual/table-management-default-input)"|
|Description|(Blank)|Set the string ("[Description](/en/manual/table-management-column-description)") to display in the item's "[Tooltip](/en/manual/user-tooltip)".|
|Input guide|(Black)|Set the "[Input Guide](/en/manual/table-management-input-guide)"|
|Auto post back|Unchecked|Set the "[Auto post back](/en/manual/table-management-auto-postback)"|
|No wrap|Unchecked|Set the "[No Wrap](/en/manual/table-management-no-wrap)"|
|Hide|Unchecked|Set the "[Hide](/en/manual/table-management-hide)"|
|Field css|(Blank)|Set the "[Field CSS](/en/manual/table-management-extended-field-css)"|
|Control css|(Blank)|Set the "[Control CSS](/en/manual/table-management-extended-control-css)"|
|Fulltext types|None|Set the "[Fulltext Types](/en/manual/table-management-full-text-type)"|
## About Date/Time Input UI
Starting from version 1.4.18.0, the date/time input UI library has been changed when using second-generation user interface themes.
If you want to revert to the old date/time input UI library, set UseOldDatepicker to true in [General.json](https://pleasanter.org/en/manual/general.json).
|New Library| Old Library|
|:---:|:---:|
|  |  |
## Related Information
<div id="ManualList"><ul><li><a href="/en/manual/table-management-editor">Manage Table: Editor</a><span>10.24.2025 up</span></li>
<li><a href="/en/manual/table-management-column-settings">Manage Table: Editor: Column Advanced Settings</a><span>10.02.2024 up</span></li>
<li><a href="/en/manual/table-management-label-text">Table Management: Editor: Item Detail Settings: Display Name</a><span>08.13.2024 up</span></li>
<li><a href="/en/manual/table-management-textalign">Table Management: Editor: Item Detail Settings: Alignment</a><span>08.13.2024 up</span></li>
<li><a href="/en/manual/table-management-required">Table Management: Editor: Item Detail Settings: Input Required</a><span>08.13.2024 up</span></li>
<li><a href="/en/manual/table-management-editor-format">Table Management: Editor: Item Detail Settings: Editor Format</a><span>08.13.2024 up</span></li>
<li><a href="/en/manual/table-management-bulk-update">Manage Table: Editor: Column Advanced Settings: Allow Bulk Update</a><span>10.02.2024 up</span></li>
<li><a href="/en/manual/table-management-copy-by-default">Manage Table: Editor: Column Advanced Settings: Copy with Default Value</a><span>10.02.2024 up</span></li>
<li><a href="/en/manual/table-management-input-guide">Manage Table: Editor: Column Advanced Settings: Input Guide</a><span>10.29.2024 up</span></li>
<li><a href="/en/manual/table-management-readonly">Table Management: Editor: Item Detail Settings: Read-only</a><span>08.13.2024 up</span></li>
<li><a href="/en/manual/table-management-default-input">Manage Table: Editor: Column Advanced Settings: Default Value</a><span>10.02.2024 up</span></li>
<li><a href="/en/manual/table-management-column-description">Manage Table: Editor: Column Advanced Settings: Description</a><span>05.26.2025 up</span></li>
<li><a href="/en/manual/table-management-auto-postback">Table Management: Editor: Item Detail Settings: Auto Postback</a><span>08.13.2024 up</span></li>
<li><a href="/en/manual/table-management-no-wrap">Table Management: Editor: Item Detail Settings: No Wraparound</a><span>08.13.2024 up</span></li>
<li><a href="/en/manual/table-management-hide">Table Management: Editor: Item Detail Settings: Hidden</a><span>08.13.2024 up</span></li>
<li><a href="/en/manual/table-management-extended-field-css">Table Management: Editor: Item Detail Settings: Field CSS</a><span>08.13.2024 up</span></li>
<li><a href="/en/manual/table-management-extended-control-css">Table Management: Editor: Item Detail Settings: Control CSS</a><span>08.13.2024 up</span></li>
<li><a href="/en/manual/table-management-full-text-type">Table Management: Editor: Item Detail settings: Full Text Type</a><span>08.13.2024 up</span></li></ul></article>
<ul><li><a href="/en/manual/table-management-style">Table Management: Style</a><span>08.13.2024 up</span></li></ul></article>
<ul><li><a href="/en/manual/user-tooltip">Common Function: Tooltip Display When Selecting User Or Group</a><span>08.14.2024 up</span></li></ul></article></div><input id="SearchTextHidden" type="hidden" value="" />
## In Case There Are Not Enough items
If 26 items from A to Z such as "「Class items」", "「Numeric value items」", "「Date items」", "「Check items」", "「Description items」" are not enough, the number of items can be expanded to 27 or more by using the "Enterprise Edition". For more information on the "Enterprise Edition", please refer to "[Here](/support)" (Japanese text only). For information on how to obtain a trial version of the "Enterprise Edition", please contact us at "[Contact](https://implem.co.jp/contact)" (Japanese text only).