Custom Time-Frame Modifiers | Community
Skip to main content
SamanthaIsin
SamanthaIsin
Level 7
July 21, 2020
Solved

Custom Time-Frame Modifiers

  • July 21, 2020
  • 1 reply
  • 576 views

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!

    This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.
    Best answer by Doug_Den_Hoed_AtAppStore

    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

    1 reply

    Doug_Den_Hoed_AtAppStore
    Community Advisor
    Doug_Den_Hoed_AtAppStoreCommunity AdvisorAccepted solution
    Community Advisor
    July 21, 2020

    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
    SamanthaIsinAuthor
    Level 7
    July 22, 2020

    That's awesome! Thank you!

    Terms & ConditionsAccessibility statement

    Loading footer...