Calculating today's date using the string functions

Calculating today's date is one of those problems every BI developer encounters sooner or later. It is also a repeatedly asked question on Internet forums; probably because books do not cover this topic at all, or at least, not with concrete examples.

The Date dimension in the Adventure Works DW 2016 SSAS database has dates only up to December 31, 2014. If we are creating a current date expression, that is, after December 31, 2014, then the expression will not be valid. To overcome this little inconvenience, we will use string functions to only get the day and month of the current date, with the year being shifted to any year we need to.

In fact, this approach can not only explain the concept well, ...

Get MDX with Microsoft SQL Server 2016 Analysis Services Cookbook - Third Edition now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.