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 don't cover this topic at all or at least not with concrete examples.
The reason behind this might be in the very nature of the calculation the result of the query executed by a reader on a particular date must inevitably differ from the result shown in the book. An additional reason might be that the implementation of the
Date dimension in Adventure Works surely differs in some cases from the
Date dimension in a concrete project that the reader is working on. There are just too many options with the formatting of dates. ...