Date Value
- What is it? Extract part of the date (day, month, year, day of week, week of year) from a date and save the result.
Limitations
This calculation cannot manipulate non all day booking event dates.
Inputs
This formula requires the following inputs to be passed through to it:
- Date the date to return a part of
- Date Format the input format of the date
- Return the part of the date to return from Day of the week, Day, Month, Year or Week of year.
Return values
The day of week, the day, the month, the year, or the week of the year.
Formula Logic
-
A new DateTime object is created from the Date Format and Date inputs
-
If the Return option is Day of the week the date is returned in the format D (Mon, Tues, Wed, Thurs etc...).
-
If the Return option is Day the date is returned in the format d (1, 2, 3... 21, 22 etc...).
-
If the Return option is Month the date is returned in the format m (Jan = January, Feb = February etc...).
-
If the Return option is Year the date is returned in the format Y (2000).
-
If the Return option is Week of year the date is returned in the format W (1, 2, 3 etc...).
-
If an exception occurs for example, the DateTime object cannot be created from the input date an empty string is returned.