Web Development·11,942 discussions

Getting a Date

Locked

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.

Topic

Reply To: Getting a Date

In reply to Getting a Date

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.

Reply To: Getting a Date

In reply to Reply To: Getting a Date

Poster rated this answer.

Reply To: Getting a Date

In reply to Getting a Date

This question was closed by the author

[Author]

Replies