Hello,
I've been gone so long from the community, I feel like a noob now.
So .... I'm looking for all projects that has hours between 6 months ago (basically August 1, 2019 - October 31, 2019) and does not have hours between Nov 1, 2019 - January 31, 2020, plus a few other requirements related to the project.
Now, I can't do this with an hour report AFAIK, it won't generate anything with an hour null filter (so null entryDate Nov 1- Jan 31 does not work).
I thought I'd do a project report, showing actualHoursLastThreeMonths which is an actual field available in project reports which means I can filter out anything that has hours in it (covers Nov 1 - Jan 31). This would have been fine except I really want to see the total hours I have that's entered between Aug 1 - Oct 31 in the report. I thought about adding hour collection but I have not seen how to write specific dates if I decide to use IF.
eg IF(entrydate>Aug1), and so on so forth. What is August 1, 2019 in text mode?
Any other ideas on how I could possibly do this, even in another alternative way?
