Despite the possibility of doing this, the recommendation absolutely has to be to never do this. Never use any reference to the current date in a view selection formula. If you have more than a few hundred documents in this database, it can kill the performance of the server. Instead, use the suggestion of using a status field. Another good addition is to categorize by the year and month so that users can drill down to a specific month. Another flourish to this idea is to wrap it in a form using a single-category embedded view. <HR> dt1:=@Adjust(@Today;0;0;29;0;0;0); dt2:=@Adjust(@Today;0;0;91;0;0;0) ; SELECT Form = "Form Name" & @uppercase(ProjectStatus) = "OPEN" & targetdate> dt1 & targetdate< dt2 NOTE: I'd try an actual hardcoded date first The compare @NOW or @Today to the hardcoded date Hardcode a date like this [04/17/2008] being today you might need @date(targetdate) Also, you may want to use a single view that includes all open items instead of having a view for each category. For instance, the selection criteria would be SELECT Form = "Form Name" & @uppercase(ProjectStatus) = "OPEN" Then add a category with this code: dt1:=@Adjust(@Today;0;0;29;0;0;0); dt2:=@Adjust(@Today;0;0;91;0;0;0) ; @if( targetdate< dt1; "1. Less Than 30 days"; targetdate> dt1 & targetdate < dt2; "2. 30 - 90 days"; targetdate > dt2; "3. Greater Than 90 days"; "Not Categorized") Thank you both for helping me, I ended up doing the single view using the categories. I do reallly appreciate the time you took out of your busy schedules to help me. thanks again Matjo

Despite the possibility of doing this, the recommendation absolutely has to be to never do this. Never use any reference to the current date in a view selection formula. If you have more than a few hundred documents in this database, it can kill the performance of the server. Instead, use the suggestion of using a status field. Another good addition is to categorize by the year and month so that users can drill down to a specific month. Another flourish to this idea is to wrap it in a form using a single-category embedded view. <HR> dt1:=@Adjust(@Today;0;0;29;0;0;0); dt2:=@Adjust(@Today;0;0;91;0;0;0) ; SELECT Form = "Form Name" & @uppercase(ProjectStatus) = "OPEN" & targetdate> dt1 & targetdate< dt2 NOTE: I'd try an actual hardcoded date first The compare @NOW or @Today to the hardcoded date Hardcode a date like this [04/17/2008] being today you might need @date(targetdate) Also, you may want to use a single view that includes all open items instead of having a view for each category. For instance, the selection criteria would be SELECT Form = "Form Name" & @uppercase(ProjectStatus) = "OPEN" Then add a category with this code: dt1:=@Adjust(@Today;0;0;29;0;0;0); dt2:=@Adjust(@Today;0;0;91;0;0;0) ; @if( targetdate< dt1; "1. Less Than 30 days"; targetdate> dt1 & targetdate < dt2; "2. 30 - 90 days"; targetdate > dt2; "3. Greater Than 90 days"; "Not Categorized") Thank you both for helping me, I ended up doing the single view using the categories. I do reallly appreciate the time you took out of your busy schedules to help me. thanks again Matjo