Excel Date Functions (MDX)
A set of Excel like functions supported by icCube
Return
void
Description
A list of Excel Text functions to follow MDX standard. We would advise using Java function if available instead.
- CDate(string s), converts a string into a datetime using formats as ('M/d/y h:m:s','M/d/y', 'M-d-y h:m:s'... )
- Now(), returns the current datetime
- Year(date), returns the year of the parameter date / datetime
- Month(date), returns the month of the parameter date / datetime
- Day(date), returns the day of the month of the parameter date / datetime
See Also
Excel Conversion Functions Java Functions
Examples
XMLA Properties
Find here the value of the XMLA properties when not specified otherwise.