The most important part of the date table is the YEAR function, ... Expand the Date table, and add Date to the Field bucket (Figure F). Figure F. Configure the YTD quick measure. 7.

There is an easier, more effective solution and in this article we will provide you with a macro formula which will help with the automatic update of information. What is the macro to update dates in ...