Question 2 Replies 3646 Views × Close popover Venkat Varri (VenkatV1572) CapitalOne CapitalOne US View Profile Send Message VenkatV1572 Member since 2016 1 post CapitalOne Posted: October 27, 2016 Last activity: October 31, 2016 Posted: 27 Oct 2016 11:31 EDT Last activity: 31 Oct 2016 1:51 EDT 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*** Reporting Support Case Exists Share × Close popover Facebook Twitter Linkedin Email Copy Link Copied! Moderation Team has archived post, learn more × Close popover This thread is closed to future replies. Content and links will no longer be updated. If you have the same/similar Question, please write a new Question. Posted: 4 years ago Posted: 28 Oct 2016 1:41 EDT × Close popover Gisela Rodrigues (rodrg) PEGA Technical Lead, Global Client Support Pegasystems Inc. IN View Profile Send Message rodrg PEGA replied to VenkatV1572 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 Posted: 4 years ago Posted: 31 Oct 2016 1:51 EDT × Close popover Rajiv Nistala (nistr) PEGA Senior Manager - Engineering Pegasystems IN View Profile Send Message nistr PEGA replied to VenkatV1572 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.