Date
Overview¶
In the "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¶
- In the "Community Edition", you cannot place more than 27 "Date" items.
- In "Pleasanter.net", you cannot place more than 27 "Date" items.
- You cannot enter dates and times outside the range of 1900/1/1 to 2099/12/31 23:59:59.
- When entering dates and times from the calendar, you cannot select years outside the range of 1950 to 2050.
- 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.
- 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¶
- "Site Administration Permission" is required to configure settings.
Advanced Settings¶
For advanced settings, refer to "Input Column Advanced Settings".
| Setting item name | Default value | Description |
|---|---|---|
| Name displayed | DateA - DateZ | "Name Displayed" is read only. It cannot be made editable. |
| Text alignment | Left alignment | Set the "Text Alignment" |
| Style | Normal | Set the "Style" |
| Required | Unchecked | Set the "Required" |
| Allow bulk update | Unchecked | Set the "Allow Bulk Update" |
| Duplication prohibited | Unchecked | Set the "Duplication Prohibited" |
| Copy with default values | Unchecked | Set the "Copy with Default Values" |
| Read only | Unchecked | Set the "Read Only" |
| Editor format | Date | Sete the "Editor Format" |
| Default value | (Blank) | Set the "Default Value" |
| Description | (Blank) | Set the string ("Description") to display in the item's "Tooltip". |
| Input guide | (Black) | Set the "Input Guide" |
| Auto post back | Unchecked | Set the "Auto post back" |
| No wrap | Unchecked | Set the "No Wrap" |
| Hide | Unchecked | Set the "Hide" |
| Field css | (Blank) | Set the "Field CSS" |
| Control css | (Blank) | Set the "Control CSS" |
| Fulltext types | None | Set the "Fulltext Types" |
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.
| New Library | Old Library |
|---|---|
 |  |
Related Information¶
- Manage Table: Editor
- Manage Table: Editor: Column Advanced Settings
- Manage Table: Editor: Column Advanced Settings: Name Displayed
- Manage Table: Editor: Column Advanced Settings: Read-only
- Manage Table: Editor: Column Advanced Settings: Alignment
- Manage Table: Style
- Manage Table: Editor: Column Advanced Settings: Input Required
- Manage Table: Editor: Column Advanced Settings: Allow Bulk Update
- Manage Table: Editor: Column Advanced Settings: Duplication Prohibited
- Manage Table: Editor: Column Advanced Settings: Copy with Default Value
- Manage Table: Editor: Column Advanced Settings: Editor Format
- Manage Table: Editor: Column Advanced Settings: Description
- Common Function: Tooltip Display When Selecting User Or Group
- Manage Table: Editor: Column Advanced Settings: Auto post back
- Manage Table: Editor: Column Advanced Settings: No Wraparound
- Manage Table: Editor: Column Advanced Settings: Hidden
- Manage Table: Editor: Column Advanced Settings: Field CSS
- Manage Table: Editor: Column Advanced Settings: Control CSS
- Manage Table: Editor: Column Advanced Settings: Fulltext Types
- General.json
- Manage Table: Items: Class
- Manage Table: Items: Numeric Value
- Manage Table: Items: Check
- Manage Table: Items: Description
- Contact
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" (Japanese text only). For information on how to obtain a trial version of the "Enterprise Edition", please contact us at "Contact" (Japanese text only).