fbpx

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.