Your achievements

Level 1

0% to

Level 2

Tip /
Sign in

Sign in to Community

to gain points, level up, and earn exciting badges like the new
Bedrock Mission!

Learn more

View all

Sign in to view all badges

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? :face_with_tears_of_joy: 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

0 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