Last Date of Next Month: SSRS

Question

I have a date, for example, 12/14/2011.

I would like to get the last day of the next month, which would be 01/31/2012.

How can I achieve this in SSRS.

Possible duplicate of [SQL Server: calculating date ranges](https://stackoverflow.com/questions/5539517/sql-server-calculating-date-ranges) — Steve-o169, Apr 09 '19 at 15:17

score 0 · Answer 1 · edited May 23 '17 at 10:34

0

This has been answered at this link: https://stackoverflow.com/a/5539615/168703. One of your datasets in reporting services should reference a common place for all date functions. And then you can use the date functions to set parameters.

I have highlighted step by step how to do this for reporting services with screen shots in that link.

edited May 23 '17 at 10:34

Community

1
1

answered Dec 14 '11 at 17:24

JonH

32,732
12
87
145

Last Date of Next Month: SSRS

1 Answers1