Difference between revisions of "Special Handling of Date Values"
Line 1: | Line 1: | ||
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. | 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. | ||
+ | |||
+ | dateUnit values include: | ||
+ | * 'Y' for Year | ||
+ | * 'Q' for Quarter | ||
+ | * 'M' for Month | ||
+ | * 'WD' for Weekday | ||
+ | * 'D' for Day | ||
+ | * 'h' for Hour | ||
+ | * 'm' for minute |
Revision as of 07:08, 13 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.
dateUnit values include:
- 'Y' for Year
- 'Q' for Quarter
- 'M' for Month
- 'WD' for Weekday
- 'D' for Day
- 'h' for Hour
- 'm' for minute
Comments
Enable comment auto-refresher