Posted: 17 Jan 2017 22:19 EST Last activity: 25 Jan 2017 23:16 EST
How to retrieve data from DB by passing Month value alone to DATE column (yyyyMMdd)?
Hi, I have a requirement where month value is selected in the dropdown (1 to 12) and on Search I need to retrieve all the records which has the selected month in 'Date' column. The Date column holds date in 'yyyyMMdd' format.
For example if I select month value as '11', I need to get records which has month as '11' in DATE column (20161103, 20101120, xxxx11xx,....).
Report Definition is used to fetch data. I need to pass Month value to DATE column in Filters. Will there be performance issue?
Is there any Pega OOTB function to accomplish this task?
Thanks in Advance.
***Updated by moderator: Lochan to update Categories***
You can pass the OOTB Month Number(pxMonthNumber) function in the function builder of the DATE column where you want pass the month number from the Date/DateTime field in the filter column as shown in attachment. Hope this will help you.