Date Function
Date (year as Numeric, month as Numeric, day as Numeric) as DateTime
Category: | Date |
Description: | Creates a date from year, month and day values entered |
Supported Context: | FormulaField And BusinessRules |
Parameters: | |
year as Numeric | Numeric value representing a year, or reference to a field that will return a year value |
month as Numeric | Numeric value representing a month (1-12), or reference to a field that will return a month value |
day as Numeric | Numeric value representing a day (1-31), or reference to a field that will retun a day value |
Returned value as DateTime | Returns a date value using the specified "Year", "Month", and "Day" parameters |
Example #1 |
Create a date Custom Field that will automatically set the corporate fiscal year of the objects created date (e.g. May 1st). Set the formula to be: Date(Year($CreatedOn),5,1) |
Tips |
|
Related Functions | |
Additional Links |
checkbox custom field |