Day
Returns the UTC date and time interval of the entire day that is the number of days specified earlier than or later than the specified date and time.
Syntax
Day(numDays, baseDateTime, timeZone)
Enabled For
For a description of the business object categories, see Notes on "Enabled For".
| Business Object Category | Yes/No |
|---|---|
| Business Rules: Before-Save Rules | Yes |
| Business Rules: Calculation Rules (After Save, with or without Also Recalculate on Load) | Yes |
| Business Rules: Calculation Rules (Before Save or Always, without Also Recalculate On Load) | Yes |
| Business Rules: Calculation Rules (Before Save or Always, with Recalculate On Load) | Yes |
| Business Rules: Editing Rules | Yes |
| Business Rules: Initialization Rules | Yes |
| Business Rules: Read Only Rules | Yes |
| Business Rules: Required Rules | Yes |
| Business Rules: Validation Rules | Yes |
| Client Expressions | Yes |
| Object Permissions | Yes |
| Services | Yes |
| LDAP | Yes |
| Mobile | Yes |
| Quick Actions (except UI Quick Actions) | Yes |
| UI Quick Actions | Yes |
| Reports | Yes |
| Search/Dashboard without field references | Yes |
| Search/Dashboard with field references | Yes |
Parameters
| Parameter | Description |
|---|---|
|
numDays |
(Optional) The number of days before or after the date and time specified by the baseDateTime parameter. If not specified or 0, uses the interval containing the date and time specified by the baseDateTime parameter. Can be either a positive integer, to indicate days after the default interval, or a negative integer, to indicate days before the default interval. |
| baseDateTime | (Optional) The base date for the function. If not specified, uses the default date which is the current date and time. |
| timeZone |
(Optional) The time zone, in IANA format. |
Returns Value
DateTime interval in UTC time.
Example
$(Day(4))
If today is April 10, 2014, this function returns the DateTime interval of the entire local day of April 14, 2014 (4 days after April 10, 2014).
$(Day(-4))
If today is April 10, 2014, this function returns the DateTime interval of the entire local day of April 6, 2014.
$(Day(10, mydate))
If the value of the mydate parameter is anytime during April 10, 2014, this function returns the DateTime interval of the entire local day of April 20, 2014.
$(Day(-4, Now(), "Africa/Cairo"))
If today is April 10, 2014, this function returns the DateTime interval of the entire local day of April 6, 2014 in the Africa/Cairo time zone.