Knowledge Base

Snippets

25

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))

First day of this year

=DateSerial( year(today()), 1, 1)

Last Day of this year

=DateSerial( year(today()), 12, 31)
Posted in: SSRS

Post Rating

Comments

There are currently no comments, be the first to post one!

Post Comment

Only registered users may post comments.