Question
CapitalOne
US
Last activity: 31 Oct 2016 1:51 EDT
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***
Pegasystems Inc.
IN
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
Pegasystems
IN
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.