Skip to main content
Kundanism
Kundanism
Level 10
September 28, 2020
Solved

Guidance to write code for condition in Report Prompts?

Hi,

Looking for your guidance;

thing to write in condition to collect all tasks more than 3 months but less than 6 months in Task type report. Please refer attachment.

Mvh

Kundan

    This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.
    Kundanism
    KundanismAccepted solution
    Level 10
    September 29, 2020

    Hi @Sarah Nau‚

    Just a small question, if the condition for the same search is based upon task entry date not Planned completion date, then will the below will be applicable (task entry date between >3<6 mnd);

    entryDate=$$TODAY-6m&entryDate_Mod=between&entryDate_Range=$$TODAY-3m

    Looking for your guidance. Sorry I forgot to mention about Task entry date instead of Task planned completion date.

    Mvh

    Kundan.

    View in thread

    5 replies

    SarahNa
    Level 6
    September 28, 2020

    Hi Kundan,

    Would this work?

    plannedCompletionDate=$$TODAY-6m&plannedCompletionDate_Mod=between&plannedCompletionDate_Range=$$TODAY-3m

    Translate
      Kundanism
      KundanismAuthor
      Level 10
      September 29, 2020

      Hi @Sarah Nau‚

      Thanks a lot. 👍

      Mvh

      Kundan

      Translate
      SarahNa
      Level 6
      September 29, 2020

      Looks good to me! When building custom prompts, I will create a new blank report and put in the filters for what I want my prompt to do, then switch to text mode. Between each line of code, add an '&' and remove the line break. Then copy and paste into the prompt on your current report. Hope that helps!

      Translate
        Kundanism
        KundanismAuthor
        Level 10
        October 1, 2020

        Hello @Sarah Nau‚

        Again, thanks a lot lot to confirm, in the meanwhile tested in report and worked great.

        Have a nice evening!

        Mvh

        Kundan

        Translate
        Terms & ConditionsAccessibility statement

        Loading footer...