Now that we know how to create expressions and custom functions, let's have a look at some typical examples of how expressions can help us achieve our goals when creating reports.
The following function can be used to display the current date:
The following function can be used to calculate new dates based upon an existing date:
=DateAdd(DateInterval.Month, 6, Parameters!ExpirationDate.Value)
In this example, starting from the expiration date, you add
6 months to it to calculate a new date. The number
6 can be any number and, when it is negative, you can subtract periods from a date.
Minute, and so on.
The following function retrieves the year from a ...