Question
Expression in Report Definition
How can I write below expression in report definition column source?
@(Pega-RULES:DateTime).FormatDateTime(@(Pega-RULES:DateTime).CurrentDateTime(), "MMMMM", "", "")
My use case is to populate Month Name like Jab, Feb -- - Dec from PXcreateDateTime property.
Accepted Solution
In the Date Time format, use custom and set MMMMM as format, you will get month name in report.
If you want to get the month name like Jan, Feb. then use MMM as a format.
Please find the below screenshot for more details.
Hi
You can not write the expression in the Report column.
The above expression is giving you current month. What is the use case for this to have it in a report?
Hi Yathender,
I have some coloumns in report definition like work object id, and createdatetime.
I want only month name to populate in pxcreatecreatedatetime as a column source
There is function The month number of [Date Value] which will give you the number between 1 and 12.
oh Sorry, I forgot to mention, I need month name like Jan, Feb in the column source
Thanks
Are you trying to format the DateTime? If yes you can use the Format option for the report column.
Click on the gear icon and select the Data Time as Column Format, then click on the search icon to select the required format.
Please find the below screenshot for more details.