Condition in RD to fetch last 6months data
HI,
I have Section to display data which source is DataPage and I have column MONTH(property) which is integer type and I need to display last 6 months data in UI so please suggest me what condition can I add in my report definition that will fetch last 6Months data of that month property.
Thank you in Advance.
Accepted Solution
Updated: 19 Jul 2023 12:30 EDT
Infosys Limited
IN
You can use the following function for your requirement.
@FormatDateTime(@addCalendar(@CurrentDateTime(),"0","-6","0","0","0","0","0"),"yyyyMMdd","IST","") which displays the date before 6 months.
For example, if the Today date is 6th May 2020, the date before 6 months 5th December 2019.
Please find the link https://support.pega.com/question/needs-show-past-6-month-date-todayscurrent-date-calendar
Which explains to set the property and pass that property to the report definition which fetches the last 6 months data.
Infosys Ltd
IN
Thank you
For our requirement this function helped and set this function as PRE-DT of flow action and added filter in RD.
Infosys Ltd
IN
So for the current implementation if we create case as on 25/07/2023 last 6 six months data is displaying. But requirement is if I create case in July irrespective of date when case is created data should display of past 6months i.e, for example 1st of Jan to 30 of June.
Please give any idea for how to do this.