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.
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, ...