Loading...
Quick Links

Reply To: Pull in Current (Today's Date) as a variable or formula to filter

Home Forums Discussion Pull in Current (Today's Date) as a variable or formula to filter Reply To: Pull in Current (Today's Date) as a variable or formula to filter

#415558
Ismet Kocaman
Guest

Matt,

Regarding your first post; Project 2010 and later versions no longer allows you to compare the Start field with the fields containing date data in a custom filter, by the introduction of manual scheduling. So, provided that Date1 contains the current date (say, it has the formula [Current Date] or now()), a filtering condition like “[Start] greater than or equal to [Date1]” does not work. You can use “[Scheduled Start] greater than or equal to [Date1]”. The Start field is now a pseudo-date field as it can also hold text information.

Date1 may contain [Current Date], or now(), or Date(), but both now() and Date() get the data from the computer’s clock. So you have flexibility of entering your current date with [Current Date] in order to test some scenarios.

Pls also watch this video to see how to insert the current date to a graphical report (Project 2013 and later):
https://www.youtube.com/watch?v=YtuTYoELwM8

— Ismet