CODEWITHSUNDEEP
reporting-services
lizfrinko
lizfrinko

Reputation: 25

How to always show the date of the 2nd in every month?

I need ssrs code that would always show me the date of the 2nd for last month. So 3/2/2019 .

I understand that this code below will always show me the 1st of last month, but how to modify to show the 2nd??

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

Upvotes: 0

Views: 251

Answers (1)

Steve-o169
Steve-o169

Reputation: 2146

I believe you're looking for simply changing the last 1 to a 2.

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

Upvotes: 0

Related Questions