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=722434I take the liberty of copying the content!.
it looks like we can also use;
project.schedule_finish >= dateMacro("today")
currentDayprevDaynextDaycurrentYearcurrentQuartercurrentMonthcurrentWeek <---- so thats the one I'm after :grin:prevYearprevQuarterprevMonthprevWeeknextYearnextQuarternextMonthnextWeekas the dateMacro("***") parameter.
Cheers!
Pablo
------------------------------
[Designation]
PPM Sr Consultant
SAM
[City]Argentina
------------------------------
Original Message:
Sent: 01-20-2020 10:57 AM
From: Arunachalam Angusamy
Subject: Power Filter - Finish date on Project Object
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
Original Message:
Sent: 01-20-2020 10:52 AM
From: Pablo Cuomo
Subject: Power Filter - Finish date on Project Object
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
Original Message:
Sent: 01-20-2020 09:40 AM
From: Arunachalam Angusamy
Subject: Power Filter - Finish date on Project Object
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.