<div>
We've always taken the route of using DATEDIFF--more robust and you can keep errors from popping up if bad data appears....
</div>


We've always taken the route of using DATEDIFF--more robust and you can keep errors from popping up if bad data appears....

<div>
Note that you can use the DATEDIFF function that is intrinsic to TSQL, rather than the VBA one.
</div>


Note that you can use the DATEDIFF function that is intrinsic to TSQL, rather than the VBA one.

<div>
<div class="content wysiwyg-content">
Please advise if I'm in the wrong area to ask this.<br />
<br />
I want to make a calculated member &quot;age of employee&quot; based on a dimension attribute<br />
Employee.birth_date<br />
<br />
Iimagine this would be something like<br />
<br />
truncate( NOW() - Employee.birth_date )<br />
<br />
IF MDX does date arithmetic !<br />
Does it? and if so what syntax works?<br />
<br />
Otherwise I have read a way ( media.wiley.com/product_da<wbr />ta/excerpt<wbr />/ 67/04714004/0471400467.pdf<wbr /> &nbsp;dated June 2001)<br />
to do this calling VBA!DateDiff
</div>
</div>


Please advise if I'm in the wrong area to ask this.

I want to make a calculated member "age of employee" based on a dimension attribute
Employee.birth_date

Iimagine this would be something like

truncate( NOW() - Employee.birth_date )

IF MDX does date arithmetic !
Does it? and if so what syntax works?

Otherwise I have read a way ( media.wiley.com/product_data/excerpt/ 67/04714004/0471400467.pdf  dated June 2001)
to do this calling VBA!DateDiff

Analysis services - MDX date calculation

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.