## Overview Find the date for the specified year, month, and day. ## Syntax ``` $DATE(Year, Month, Day) ``` ## Parameters |Parameter|Type|Required|Description| |:---|:---|:---|:---| |Year|4-digit half-width numerical value|Required|Specify 1900 or higher. An error occurs if the number is less than 1900. An error occurs if the string is not a half-width numerical value. | |Month|Half-width numerical value|Required|If a value other than 1 to 12 is entered, the past or future month is calculated using the input value. An error occurs if the string is not a half-width numerical value. A blank is considered to be 0. | |Day|Half-width numerical value|Required|If a value other than 1 to 31 is entered, the past or future day is calculated using the input value. An error occurs if the string is not a half-width numerical value. A blank is considered to be 0. | ### Items Usable as Parameters |Parameter|Classification|Numerical Value|Date|Description|Check| |:---|:---|:---|:---|:---|:---| |Year|Yes|Yes|No|Yes|No| |Month|Yes|Yes|No|Yes|No| |Day|Yes|Yes|No|Yes|No| ## Return Value Date in yyyy/mm/dd format. ### Return Value Display Content |Target|Display Content of Return Value| |:---|:---| |Classification (including title, status, administrator, person in charge)|Display return value. | |Numerical Value (including workload, progress rate, remaining workload)|Do not display. | |Date (including start and completion)|Display return value. If the editor format is "Date and time (minutes)" or "Date and time (seconds)", 00:00:00 will be automatically completed. | |Description (including content)|Display return value. | |Check (including lock)|Do not display. | ## Usage Example ① Specify parameters by screen item name (display name) ### Formula  ### Parameters  ### Calculation Result Editor format: Year/Month/Date  Editor format: Date and time (seconds)  ## Usage Example ② When month is 0 ### Parameters  ### Calculation Result  ## Usage Example ③ When day is a negative value ### Parameters  ### Calculation Result