Clarity

 View Only
  • 1.  Power Filter - Finish date on Project Object

    Posted Jan 20, 2020 09:40 AM
    Hi 

    I am trying to apply the power filter on schedule finish. I wanted to see the project that has finish date which is greater than or equal to 2019.


  • 2.  RE: Power Filter - Finish date on Project Object

    Posted Jan 20, 2020 10:52 AM
    Hi there!
    Did you try to change year for date, like project.schedule_finish >= date("2020")

    I believe this is based on scripting expressions.

    Cheers, Pablo

    ------------------------------
    [Designation]
    PPM Sr Consultant
    SAM
    [City]Argentina
    ------------------------------



  • 3.  RE: Power Filter - Finish date on Project Object
    Best Answer

    Posted Jan 20, 2020 10:57 AM
    Thank you!. I do NOT want to hard any value. I tried this below one and it works well 

    project.schedule_finish >= dateMacro("currentYear") -1


  • 4.  RE: Power Filter - Finish date on Project Object

    Posted Jan 20, 2020 11:02 AM
    Super, I was searching because i remember a solution, and yes! found it, like you wrote.

    Here you have. https://community.broadcom.com/communities/community-home/digestviewer/viewthread?MID=722434

    I take the liberty of copying the content!.

    it looks like we can also use;


    project.schedule_finish >= dateMacro("today")

    currentDay
    prevDay
    nextDay
    currentYear
    currentQuarter
    currentMonth
    currentWeek <---- so thats the one I'm after :grin:
    prevYear
    prevQuarter
    prevMonth
    prevWeek
    nextYear
    nextQuarter
    nextMonth
    nextWeek

    as the dateMacro("***") parameter.

    Cheers!
    Pablo

    ------------------------------
    [Designation]
    PPM Sr Consultant
    SAM
    [City]Argentina
    ------------------------------