Question
3
Replies
1816
Views
Virtusa Corporation
Posted: December 17, 2017
Last activity: December 19, 2017
Get 1st of every month
Hi,
I have a requirement to get list of records data from 1st of current month to till date.
Can anyone suggest please is there a function i can set 1st of current month date time value to a property.
Thanks.
Accepted Solution
Posted: 2 years ago
Posted: 2 years ago
Hi Praveen,
If you have a option to use ReportDefinition then we have current Month option in filter to get the list.
Regards,
Ujjwal
Posted: 2 years ago
Just to add to my colleagues' (bagas) suggestion,
Please configure suggested the function in data transform and setting the value in a property for evaluation as I have faced multiple issues when using multi-layer embedded functions.
Hi,
You can use DateTime utility functions for your requirement. One possible way is here.
Get the year and month from current time stamp. Then create a new date with the month and year fetched from current time stamp, and with default the date part to "1". Note that @month utility gives the months in 0-11 format so you need to increment it before passing to Date function.
@(Pega-RULES:DateTime).date(@year(@toDateTime(@CurrentDateTime())),@month(@toDateTime(@CurrentDateTime()))+1,"1")
Thanks,
Santhosh