CODEWITHSUNDEEP
reporting-servicesssrs-2008-r2
Brett Cooper
Brett Cooper

Reputation: 39

First and last day of next month ssrs

Stuck trying to figure out how to find the first and last day of the next month, the month after that and then again after that.

Upvotes: 2

Views: 3153

Answers (1)

alejandro zuleta
alejandro zuleta

Reputation: 14108

For first day of next month:

=DateSerial(Year(Now()), Month(Now()), "1").AddMonths(1)

For last day next month:

=DateSerial(Year(Now()), Month(Now()), "1").AddMonths(2).AddDays(-1)

One month after the current month:

=DateSerial(Year(Now()), Month(Now()), "1").AddMonths(2)
=DateSerial(Year(Now()), Month(Now()), "1").AddMonths(3).AddDays(-1)

Two months after the current month:

=DateSerial(Year(Now()), Month(Now()), "1").AddMonths(3)
=DateSerial(Year(Now()), Month(Now()), "1").AddMonths(4).AddDays(-1)

Let me know if this helps.

Upvotes: 6

Related Questions