matt23lucier
MIS
I am trying to find the MIN and MAX number of days between an open and closing date. Everything seems to work OK except when the MIN or MAX difference between dates is 0. Here is an example:
Item OpenDate CloseDate
1000 01/01/07 01/11/07
1000 05/05/07 05/10/07
1000 10/10/07 10/10/07
In this case I would get Max days of 10 and MIN days of 5. It looks like the MIN or MAX will not include the number of days if the number is equal to 0.
Thanks
Matt
Item OpenDate CloseDate
1000 01/01/07 01/11/07
1000 05/05/07 05/10/07
1000 10/10/07 10/10/07
In this case I would get Max days of 10 and MIN days of 5. It looks like the MIN or MAX will not include the number of days if the number is equal to 0.
Thanks
Matt