1 Reply Latest reply on Jan 27, 2013 8:11 PM by christinesephton

    How can I filter a specific number from a range of numbers?


      Hi all, this is my first post so hopefully it will be the beginning of a long lasting relationship!


      Here's my problem:


      I have a number of tasks that are conducted throughout the year, some are weekly, some monthly etc.


      I want the weekly tasks to pop up on a to do list at the start of each week.


      Here's how my head works:


      1. I can allocate the task a week number and filter for each week (1 to 52). I would need to copy the task 52 times and number each one 1 - 52.

      2. I put in some script to say if task = 52 then produce each week.

      3. I put in a script that will repeat the task every Monday throughout the year.


      Can anyone help (even I realise option one is not good!!)


      Thanks in anticipation



        • 1. Re: How can I filter a specific number from a range of numbers?

          I would consider using a server script (or client if you do not have server..just has to be done manually) that would run every Monday.


          I would set the script to perform certain tasked based on the date and the type.




          Weekly Might Be:


          IF [Task Type="Weekly" and DayOfWeek(Get(CurrentDate))=2)]  //Look to see if the Day of the Week is Monday and if so it runs!

          DO SOME TASK

          END IF


          Monthly Might Be:


          IF[Task Type="Monthly" and


          [d=Get(CurrentDate);m=Date(Month(d);Day(1);Year(d));dow=DayOfWeek(m)]; //Looks for the first Monday of the Month and if the Current Date matches it runs!


          DO SOME TASK

          END IF


          Just a suggestion. Not really too clear on what exactly you are doing..or how..but perhaps this will help?