Tuesday, April 8, 2014

Getting the quarter for a particular date in Reporting Services

Nice, simple, little solution here, but oddly couldn't find anything simple online, so here goes.

If you have a date, and you want to display the quarter for that date (for example, January = 1, April = 2, December = 4), this expression will do the trick (assuming that the date you want to report on is called Modified):

=CEILING(Month(Fields!Modified.Value)/3)

No comments:

Post a Comment