How do I create custom date functions for reports?
I'm building reports, and have found out how to do things like extract the month number out of a date. The function screen allows the following:
So my question is, if I want to do other things such as get the month Name, name of the day of the week, or other standard date-library type functions, how can I add to what is available here?
Pegasystems
IN
The following PDN article tells how to add new SQL functions - https://pdn.pega.com/reporting/how-to-create-custom-sql-functions-for-reporting
Centene
US
Rajiv
That sort of helps...but i am really lost on the syntax/process of creating this type of thing. The "Presentation Template" and "Echo Template", for example, make absolutely no sense to me. The syntax in the article provided, using "(1)" - is this a parameter reference? When I put my method in using what I think is correct based on the article, then when I reference this new function in the report definition, the screen just hangs when I press Submit:
