Additionally the long form with an actual date value will allow things like graphs with date as the xaxis that the original data would not support.   Date values also can create groups of values just by changing the format. If you want to get an average balance for a quarter use any of the report or summary functions with the date variable and change the format to yyQ. Or a calendar summary by using applying the YEAR format to the same report. ... View more