Custom Time-Frame Modifiers

[SamanthaIsin]

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!

[Doug_Den_Hoed__AtAppStore · Accepted solution]

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

[SamanthaIsin]

That's awesome! Thank you!