Question

2
Replies
1071
Views
Close popover
Avisek Mondal (avisekmondal)
Cognizant Technology Solutions
System Architect
Cognizant Technology Solutions
IN
avisekmondal Member since 2008 20 posts
Cognizant Technology Solutions
Posted: April 5, 2018
Last activity: April 6, 2018
Closed

Today in function alias for RD

When I use a condition pxCreateDateTime = Today in Report Definition, I could see the query gets generated as (pxcreatedatetime >= 'StartDateTime' and pxcreatedatetime <= 'EndDateTime') (where start and end date time are automatically calculated by Pega while generating the query).

How do I use this condition while creating a function alias to be used in RD? When I directly use an input param (date time type) = Today, it gives error at run time.

Reporting
Moderation Team has archived post