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.
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 Needs to show past 6 month date from today's/current date in calendar. | Support Center
Which explains to set the property and pass that property to the report definition which fetches the last 6 months data.
Thank you
For our requirement this function helped and set this function as PRE-DT of flow action and added filter in RD.
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.