we are trying to identify where a customer's project end date is the same or overlaps with the next project start date. i have used north largest to show the project start dates and it is fine. however when i use north largest on the project end date, it is showing the dates in descending order. what have i miss here?
the data is as follows:
customer name project start date project end date
customer A 1/9/2005 18/5/2009
18/5/2009 19/5/2009
19/5/2009 31/8/2010
31/8/2010 1/9/2010
1/9/2010
customer B 1/9/2003 31/8/2008
1/9/2008 3/1/2010
4/1/2010
based on what we are looking for, the report will show only customer A. how can i achieve that?
thank you.
the data is as follows:
customer name project start date project end date
customer A 1/9/2005 18/5/2009
18/5/2009 19/5/2009
19/5/2009 31/8/2010
31/8/2010 1/9/2010
1/9/2010
customer B 1/9/2003 31/8/2008
1/9/2008 3/1/2010
4/1/2010
based on what we are looking for, the report will show only customer A. how can i achieve that?
thank you.