I created a Tracking Task List to track task assigning within my small team. I am displaying the tasks in the "My Task" view for the current user where th tasks "created by" him or "assigned to" him. I created another view and call it "Due Tasks" with following criteria: 1. Items assigned to equal to [Me] 2. Items created by equal to [Me] 3. Due Date is less than or equal [Today] 4. % Completed is not equal 100 so in this view only the tasks that are Over Due and not completed I need to create an alert to send the user that the Task assigned to him when any task from the "My Task" view is added to the "Due Tasks" view. Note that this is not an overdue workflow tasks! it is just a simple tracking task library. I did my best to do it but it sends an email even if the tasks is not Over Due (I mean even if the Due Date is greater than Today Date) please help me to do it

Read both of these and you'll have a better handle on what you can do. Then formulate your own, based on your specific needs. http://sharepointmagazine.net/articles/the-dog-ate-my-task-use-sharepoint-designer-to-email-daily-task-reminders http://www.pentalogic.net/sharepoint-products/reminder/reminder-manual?p=commonscenarios%2Ftasksdueandoverdue%2Ftasks_dueandoverdue.htmSteve Clark, MCTS | Twin-Soft.com

Hi Ahmed, You can write a SharePoint designer to implement your requirement. Start the workflow whenever a new item is created. Calculate and store a variable TaskToBeCompletedIn = DueDate - Today . Now wait for TaskToBeCompletedIn day. Then check if %completed is <100 then send a mail, else task is completed. Thanks Chanakya