Your achievements

0% to

Tip / to gain points, level up, and earn exciting badges like the new

Workfront

Don’t miss the Workfront AMA: System Smarts & Strategic Starts! Ask your questions about keeping Workfront running smoothly, planning enhancements, reporting, or adoption, and get practical insights from Adobe experts.

RSVP & Ask Questions

Mark Solution

This conversation has been locked due to inactivity. Please create a new post.

SOLVED

How do I modify "past year" dates to start at the beginning of the month?

I am trying to pull a report that is pulling data for the "Past Year". The filters are currently Entry Date Between $$TODAY-1y and $$TODAY but am hoping to have the "$$TODAY-1y" start at the beginning of the month vs. exactly 1 year from today so that we can compare total numbers between August 2022 and August 2021. Any help is appreciated 🙂 Thank you!

580

2

1 Accepted Solution

Correct answer by

Use $$TODAYb-12m and $$TODAY that will give you 8/1/21 to today.

View solution in original post

576

1

Jump to reply

2 Replies

Correct answer by

Use $$TODAYb-12m and $$TODAY that will give you 8/1/21 to today.

577

1

Jump to reply

I knew it had do be something simple like that. Thank you so much 🙂

572

0

Related Conversations

Any workaround to not display HTML tag onscreen? Solved

Solved

134

0

2

Workfront Licenses Expiration Date?

130

0

1

Combine OR and AND operators in call to search API

99

0

4

Text mode for assignments not just assigned to ID

196

0

4

Scheduled Report Sends - Will they send if the report creator is inactive?

46

0

1