SSRS Date Expressions

8/10/2025

SSRS expressions to obtain the first and last days of any month, using the current month as a reference

First day of last month:

=dateadd("m",-1,dateserial(year(Today),month(Today),1))

First day of this month:

=dateadd("m",0,dateserial(year(Today),month(Today),1))

First day of next month:

=dateadd("m",1,dateserial(year(Today),month(Today),1))

Last day of last month:

=dateadd("m",0,dateserial(year(Today),month(Today),0))

Last day of this month:

=dateadd("m",1,dateserial(year(Today),month(Today),0))

Last day of next month:

=dateadd("m",2,dateserial(year(Today),month(Today),0))
‹ Back to List