Question2Replies3509Views×Close popoverVenkat Varri (VenkatV1572) CapitalOne CapitalOne US View ProfileSend Message VenkatV1572 Member since 2016 1 post CapitalOne Posted: October 27, 2016Last activity: October 31, 2016Posted: 27 Oct 2016 11:31 EDTLast 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 ×Close popoverFacebookTwitterLinkedinEmail Copy Link Copied! Moderation Team has archived post 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 agoPosted: 28 Oct 2016 1:41 EDT×Close popoverGisela Rodrigues (rodrg) PEGA Technical Lead, Global Client Support Pegasystems Inc. IN View ProfileSend Messagerodrg PEGA replied to VenkatV1572Hi 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 agoPosted: 31 Oct 2016 1:51 EDT×Close popoverRajiv Nistala (nistr) PEGA Senior Manager - Engineering Pegasystems IN View ProfileSend Messagenistr PEGA replied to VenkatV1572There 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.