N
Nathaniel Mc Intosh
Hi all,
I'm trying to compare the [Finish] date of a task to a static date (the last
day of the week in this case).
Switch([% Complete]=100,"Complete",[Finish]<Date(),"Update
Overdue",[Finish]<'20/10/2007',"Due This Week",[Start]<'27/10/2007',"Starting
Next Week",[Start]>"27/10/2007","Future Task")
When I test if the finish date is < 20/10/2007 it compares as though it was
text.
i.e. 17/10/2007 = true and 17/11/2007 also = true
25/10/2007 = false and 25/11/2007 also = false
I've tried with single and double quotes which produce the same results, and
without quotes which doesn't seem to match anything. I've also tried the 2007
year format and 07 format.
Please help
I'm trying to compare the [Finish] date of a task to a static date (the last
day of the week in this case).
Switch([% Complete]=100,"Complete",[Finish]<Date(),"Update
Overdue",[Finish]<'20/10/2007',"Due This Week",[Start]<'27/10/2007',"Starting
Next Week",[Start]>"27/10/2007","Future Task")
When I test if the finish date is < 20/10/2007 it compares as though it was
text.
i.e. 17/10/2007 = true and 17/11/2007 also = true
25/10/2007 = false and 25/11/2007 also = false
I've tried with single and double quotes which produce the same results, and
without quotes which doesn't seem to match anything. I've also tried the 2007
year format and 07 format.
Please help