CODEWITHSUNDEEP
reporting-servicesssrs-2008-r2reportbuilder3.0
user1347948
user1347948

Reputation:

Next Quarter Start and End Date SSRS

I know how to calcualte the current quarter start and end date. I even have the calcualtion for the Next Quarter Start date. However, the next quarter end date does not seem to be working for me. Can anyone tell me what I am doing wrong. 

=DateAdd("d", -1, DateAdd("q", DateDiff("q", ("1/1/1900"+2), Today), DateSerial(1900,1,1)))

Upvotes: 2

Views: 1277

Answers (1)

stubaker
stubaker

Reputation: 1958

You're very close, you need to add 2 to the first quarter calculation instead of to the date itself. So the expression should be:

=DateAdd("d", -1, DateAdd("q", DateDiff("q", ("1/1/1900"), Today)+2, DateSerial(1900,1,1)))

Upvotes: 1

Related Questions