I have an issue with the date filters I wish to create an EVA report but on a very specific customized date range and that will take into consideration every data (tasks, milestones, costs associated, etc) that exists within that specific date range.
e.g : Project start date: 1/08/2012
Project end date: 30 /12/2012
Current date : 28/08/2012
I wish to be able to create an EVA report from 15/08/2012 until 17 /09 /2012
Apparently it is not possible to filter by date (only by task’s start or finish date which is too restrictive). I’ve tried to create a custom field, but I can’t find the correct formula to call the “current date” so as to define my date range.
Is there a formula to create a custom field with regards to the current date? Is there an alternative to this issue.