Your achievements

0% to

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

Workfront

The Community Ideas review for H1 2025 is out now, see which ideas our Product team prioritized and let us know your thoughts.

Read more

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!

521

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

517

1

Jump to reply

2 Replies

Correct answer by

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

518

1

Jump to reply

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

513

0

Related Conversations

Silly question - but here it is - If a Group Admin. is a member of a Group does that give them Group Admin. rights to that Group? Solved

Solved

59

0

2

Add column to task report to show who assigned the task Solved

Solved

68

0

2

Cannot add exisiting projects to portfolio Solved

Solved

74

0

2

In the Unified Experience, is there a way to choose which instance of Workfront opens first?

39

0

1

If you are using advanced proof instead of simple proof will the document proofing buttons change?

32

0

0