User Manual

08.13.2024

MANUAL

Formula (Extended): $DAYS Function

## Overview Calculate the number of days between two dates. ## Syntax ``` $DAYS(Completion Date, Start Date) ``` ## Parameters |Parameter|Type|Required|Description| |:---|:---|:---|:---| |Completion Date|Date or date string in yyyy/mm/d format|Required|Error if start date > completion date. | |Start Date|Date or date string in yyyy/mm/d format|Required|Error if start date > completion date. | ### Items Usable as Parameters |Parameter|Classification|Numerical Value|Date|Description|Check| |:---|:---|:---|:---|:---|:---| |Completion Date|Yes|No|Yes|Yes|No| |Start date|Yes|No|Yes|Yes|No| ## Return Value Number of days. ### Return Value Display Content |Target|Display Content of Return Value| |:---|:---| |Classification (including title, status, administrator, person in charge)|Display return value. In the case of a drop-down list with values, display the options that match the return value| |Numeric Value (including workload, progress rate, remaining workload)|Display return value. | |Date (including start and completion)|Do not display. | |Description (including content)|Display return value. | |Check (including lock)|Do not display. | ## Usage Example ① Specify parameters by screen item name (display name) ### Formula ![image](https://pleasanter.org/binaries/bfacbfc14a5749e183bda4d79239fa51) ### Parameters ![image](https://pleasanter.org/binaries/6c7d25ea76574c138f9e6d0c312c5984) ### Calculation Result ![image](https://pleasanter.org/binaries/b0a6e3d55a8442d3a975986eb826ecde)
TOP
このページをシェアする
記載された商品名、各製品名は各社の登録商標または商標です。 © Implem Inc.