Create Lookahead filter
I am trying to put together a filter that will produce a lookahead programme, but does not rely on data from special columns.
The required filter will show;
tasks that start between 7 days before a user input date and a point 21 days past it (now-7 to now+21)
tasks that start between 7 days before a user input date and a point 21 days past it (now-7 to now+21)
Tasks that start more than 7 days prior to the date, and end more than 21 days after it.
this would show all tasks starting, finishing or carrying through the 4 week spread of -7/ +21 days from the user input.
I can manage this using columns, as I can use the "current date" function, from which I can produce the filter. However the filter really needs to be a standalone that works from a user input date due to restrictions I wont go into now.
I know I can use an input ("Date to set as start"?) but can I then use the input throughout, or do I have to put a new value in for each calc?
Thanks all.
|