Discussion Locked

Getting a Date

0 helpful
3 replies
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.
I'm trying to update one of my reports in SQL Reporting Services. I'm not a programmer in every sense but understand concepts to apply to a situation. I created a new column in my report to obtain a date by adding 90 days to a specific date. How can I accomplished this in Reporting Services using any of the available functions be in Reporting Services or Visual Basic.

3 replies

by eschlangen

To me, the simplest thing would be to add a computed value to your underlying query using the DATEADD function. For date x,
DATEADD('d',90,x) will give you the date that is 90 days after x.

This discussion is closed to new replies.