Explore Courses Blog Tutorials Interview Questions
0 votes
in BI by (17.6k points)
edited by

Is there any way where I can add days to a date in an expression.
Field: payment_date
and I want 15 days to be added to that date

Thanks in Advance!



1 Answer

0 votes
by (47.2k points)
selected by
Best answer

In order to control content and report appearance, Expressions are frequently used in Reporting Services paginated reports. Expressions can use built-in functions, custom code, report, group variables, and user-defined variables.

DateAdd: This function is basically used for supplying a range of dates based on a single parameter. The following expression provides a date that is three months after the date from a parameter named StartDate.

Syntax: =DateAdd(DateInterval.Month, 3, Parameters!StartDate.Value)  

Go to Expression editor, under the Common Functions in the Category window, check Date & Time functions. We cam make use of DateAdd() function.

=DateAdd("d", 15, Fields!payment_date)

You can enroll for Msbi certification training that enables you to master MSBI tools like SSIS, SSRS, and SSAS using SQL Server.  As part of this training, you will learn data integration and creation of reports, dashboards, and cubes for faster reports generation.  

Related questions

0 votes
1 answer
asked Jan 3, 2021 in SQL by Appu (6.1k points)
0 votes
1 answer
asked Feb 6, 2020 in BI by Vaibhav Ameta (17.6k points)
0 votes
1 answer
asked Jan 31, 2020 in BI by Vaibhav Ameta (17.6k points)
0 votes
1 answer
asked Feb 27, 2020 in BI by Vaibhav Ameta (17.6k points)

Browse Categories