Difference between revisions of "Special Handling of Date Values"
| Line 8: | Line 8: | ||
* [[Ceil|Ceil()]] | * [[Ceil|Ceil()]] | ||
* [[Round|Round()]] | * [[Round|Round()]] | ||
| + | * [[Sequence|Sequence()]] | ||
dateUnit values include: | dateUnit values include: | ||
| Line 21: | Line 22: | ||
Note that some of these are distinguished by case. | Note that some of these are distinguished by case. | ||
| − | + | ;Examples: | |
| − | Round up to the next year: Ceil( | + | Round up to the next year: Ceil(MakeDate(2014, 12,17), dateUnit: 'Y') → 1-Jan-2015 |
| − | Round to the nearest top of the minute: Round( | + | Round to the nearest top of the minute: Round(Now(withTime:1), dateUnit: 'm') → 17-Dec-2014 11:32:00 AM |
| − | List the next 5 Groundhog Days: Sequence(MakeDate(2015,2,2), MakeDate( | + | List the next 5 Groundhog Days: Sequence(MakeDate(2015,2,2), MakeDate(2019,2,2), dateUnit: 'Y') |
| + | → [2-Feb-2015, 2-Feb-2016, 2-Feb-2017, 2-Feb-2018, 2-Feb-2019] | ||
Revision as of 19:44, 17 December 2014
Analytica includes group of Date Functions specifically designed to create and manipulate date values. But there are also some common functions which, although they are typically applied to standard numerical values, include optional parameters to handle dates. This page links to all functions that handle dates.
The dateUnit Parameter
The dateUnit parameter is available in several rounding functions. It must be called explicitly and replaces the digits parameter.
Functions that use the dateUnit parameter:
dateUnit values include: - 'Y' for Year - 'Q' for Quarter - 'M' for Month - 'WD' for Weekday - 'D' for Day - 'h' for Hour - 'm' for minute - 's' for second
Note that some of these are distinguished by case.
- Examples
Round up to the next year: Ceil(MakeDate(2014, 12,17), dateUnit: 'Y') → 1-Jan-2015
Round to the nearest top of the minute: Round(Now(withTime:1), dateUnit: 'm') → 17-Dec-2014 11:32:00 AM
List the next 5 Groundhog Days: Sequence(MakeDate(2015,2,2), MakeDate(2019,2,2), dateUnit: 'Y') → [2-Feb-2015, 2-Feb-2016, 2-Feb-2017, 2-Feb-2018, 2-Feb-2019]
Comments
Enable comment auto-refresher