Setting Dateprompt to Previous WorkingDay

• Add DatePrompt
• Enter a valid name in the name propety of the prompt. f.e: StartDate 
• 
• Add a HTML block to ritght of the prompt
• Enter the following JavaScript block
• <script language="javascript">
       var dDate = new Date();
       //Subtract one day
       dDate.setDate(dDate.getDate()-1);
                         if (dDate.getDay() ==0) {
          dDate.setDate(dDate.getDate() -2);
      }
        if (dDate.getDay() ==6) {
          dDate.setDate(dDate.getDate() -1);
      }
       pickerControlStartDate.setValue(getFormatDate(dDate, 0 , 'YMD'));
   </script>
• If your prompt has different name change the bold part in the script
• 
   

Till Next Time

Welcome to COGNOS101

Hi,
My name is John Minkjan and I'm a senior BI-consultant at CIBER in the Netherlands (update 2016 i've since changed jobs (twice) ;-) . I reserverd a couple of ...101 blogspots. At the moment I'm mostly active on OBIEE101. I will start posting here as soon as my focus in back on to Cognos Reporting.

Till Next Time

John