date range in report definition filter

@SuryaBasani many thanks surya-- for sharing your knowledge and looking into this question :slight_smile:

Hi @SuryaBasani @Sam27

What if I user wants the results for one particular day in the range of dates

for example,

Start Date: 08/08/2022 & End Date: 08/08/2022

(the suggested condition was bringing null result)

@gupts3 Thanks for the solution. Tried out from my end but didn’t worked for me. The error is showing for CustomFilter.StartDate and CustomFilter.EndDate as Not Defined and Invalid comparision.

I’m doing as .pxCreateDateTime >= CustomFilter.StartDate AND .pxCreateDateTime <= CustomFilter.EndtDate.

Can you please help me out?

Hi @PoojaPalla,

We have two options.

  1. is greater than or equal Param.FromDate

OR

is less than or equal Param.ToDate

ex:Start Date: 08/08/2022 OR (use or condition) End Date: 08/08/2022

  1. Declare the property types date time and pass the input datetime to paramaters

is greater than or equal Param.FromDate

AND

is less than or equal Param.ToDate

ex:Start Date: 08/08/2022 9:00AM & End Date: 08/08/2022 6:00PM

Thank you,

Surya

Hi @PriyankaB1930

Thank you for posting your question on the Pega Support Center!

This appears to be an inactive thread and I would like to suggest that you ask a new question.

This will alert our SMEs of your new question and you should hopefully receive a reply soon.

You may include the original thread as a reference in your new question.

Thank you!

@Rajak9999 can use column source as pxUpdateDateTime and Value as Last 90 days in below filter condition

example created date with filter of 30 days.jpg