Question
2
Replies
3509
Views
CapitalOne
Posted: October 27, 2016
Last activity: October 31, 2016
Closed
Report Definition add day's to current date.
Wanted to add 5 days to current date and display Report Definition Column, Do we have any OOTB function.
Report Definition is not allowing below function.
@addToDate(.RepresentmentDate,5, 0, 0, 0)
***Updated by moderator: Lochan to add SR Exists tag***
Posted: 4 years ago
There is no OOTB SQL function to do this. But you can take a look at other date time functions shipped with the platform to do this.
Alternatively, you can refer to what @Gisela_R has mentioned or create a custom control that can be applied just for display purpose.
Hi Venkat,
You can create a new property and have a declare expression to set the value of the property to @addToDate(.RepresentmentDate,5, 0, 0, 0). You can then refer this property in the report definition.
I have attached a document with screenshots for your review.
Hope this helps!
Reagrds,
Gisela