Custom Time-Frame Modifiers | Community
Skip to main content
SamanthaIsin
SamanthaIsin
Level 7
Jul 21, 2020 7:59 PM UTC
Solved

Custom Time-Frame Modifiers

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.
    Doug_Den_Hoed__AtAppStore
    Doug_Den_Hoed__AtAppStoreAccepted solution
    New Participant
    Jul 21, 2020 8:27 PM UTC

    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 reply

    2 replies

    Doug_Den_Hoed__AtAppStore
    Doug_Den_Hoed__AtAppStoreAccepted solution
    New Participant
    Jul 21, 2020 8:27 PM UTC

    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

    Translate
    SamanthaIsin
    SamanthaIsinAuthor
    Level 7
    Jul 22, 2020 2:38 PM UTC

    That's awesome! Thank you!

    Translate
    Terms & ConditionsAccessibility statement

    Loading footer...