Which wildcard should be used on a project report when filtering for projects that have a planned completion date greater than 1 month from the…

In Adobe Workfront reporting, wildcard variables are used to create dynamic filters. To filter for a date that is one month in the future, the correct syntax is TODAY + 1m. The TODAY variable represents the current date, and the + 1m modifier adds exactly one calendar month to it. This combination accurately targets the desired date range for the filter.

A. TODAY + 1bm: This is incorrect because 1bm represents one "business month," which calculates based on working days, not a standard calendar month as implied by the question.

C. CURRENTDATE + 4w: This is incorrect because 4w represents four weeks (28 days). This is an imprecise approximation for a calendar month, which can have 28, 29, 30, or 31 days.

1. Adobe Experience League - Wildcard filter variables: This official documentation outlines the available wildcards for filtering in Adobe Workfront. It specifies that $$TODAY (or TODAY) represents the current date and that the m modifier is used to denote months. The b prefix is used for business time units (bm)

and w is used for weeks.

Section: "Date-Based Wildcards" and the table of "Wildcard Syntax". This section confirms +1m adds one month to the specified date variable.