Expand my Community achievements bar.

Latest Community Ideas Review is Out: Discover What’s New and What to Expect!
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
Community Advisor

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
Community Advisor

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