Expand my Community achievements bar.

The next phase for Workfront Community ideas is coming soon. Learn all about it in our blog!
SOLVED

Custom Time-Frame Modifiers

Avatar

Level 8

I need to build a custom time-frame modifier for a report. I'm not sure how the built-in modifiers work and so I wasn't able to just duplicate them. Can someone either explain how they work or help me build my own for a 6 month time frame? Or both? 😂 Thanks!

Topics

Topics help categorize Community content and increase your ability to discover relevant content.

1 Accepted Solution

Avatar

Correct answer by
Level 10

Hi Samantha,

There's a good primer on how to Add a prompt to a report including Custom Prompts; and for your six month entry (using the Date Based Variables), I'd suggest something similar to this:

plannedCompletionDate=$$TODAYbm&&plannedCompletionDate_Mod=between&&

plannedCompletionDate_Range=$$TODAYbm+6m

Regards,

Doug

View solution in original post

2 Replies

Avatar

Correct answer by
Level 10

Hi Samantha,

There's a good primer on how to Add a prompt to a report including Custom Prompts; and for your six month entry (using the Date Based Variables), I'd suggest something similar to this:

plannedCompletionDate=$$TODAYbm&&plannedCompletionDate_Mod=between&&

plannedCompletionDate_Range=$$TODAYbm+6m

Regards,

Doug