How to refer particular month of current year
How I can in activity (when) and report definition (filter condition) for particular month of current year? For example March of current year. Next year I want to have it March of 2026, etc. Is there OOTB function for this? "3/current year" does not work.
Accenture
IN
Hi @MartinM46,
Pega doesn't have this OOTB feature for solving this. Custom Function can be written or you can hardcode the month. Hope this helps.
Saltech Consulting
HU
@MartinM46 You can dynamically refer to a specific month (e.g., March) of the current year using OOTB functions in both Activity (When condition) and Report Definition (Filter Condition). For Activity (When condition) To get March 1st of the current year: @toDate("03-01-" + @FormatDateTime(@CurrentDateTime(), "yyyy", ""), "MM-dd-yyyy") For the last day: @toDate("03-31-" + @FormatDateTime(@CurrentDateTime(), "yyyy", ""), "MM-dd-yyyy") For Report Definition (Filter Condition) Use these conditions to filter records for March of the current year:
ColumnName >= @DateTime.toDate("03-01-" + @FormatDateTime(@CurrentDateTime(), "yyyy", ""), "MM-dd-yyyy") AND ColumnName <= @DateTime.toDate("03-31-" + @FormatDateTime(@CurrentDateTime(), "yyyy", ""), "MM-dd-yyyy") This ensures that the filter dynamically updates each year without manual changes. Hope this helps!