4 Replies Latest reply: Nov 21, 2014 3:05 PM by Srikanth P RSS

    General Date Scripting help

      Hi

       

      More a general scripting query, rather than a QV specific query.

      However it  is really wearing me down, any help would be greatly apprciated.

      I have the columns MSN, Date and Day Dif, I want to add the columns calculating the missing dates, in the format below.

       

      MSNDateDay DifJanFebMarAprMayJunJulAugSepOctNovDec
      11640305/01/201513.22%00000000000
      11640401/01/201413.22%00000000000
      11640402/01/201413.22%00000000000
      11640403/01/201413.22%00000000000
      11640404/01/201413.22%00000000000
      11640405/01/201413.22%00000000000
      11640406/01/201413.22%00000000000
      11640408/01/201426.44%00000000000
      11640409/01/201413.22%00000000000
      11640402/02/20142470.90%

      7.14%

      0000000000
      11640403/02/201410

      3.57%

      0000000000
      11640404/02/2014103.57%0000000000
      11640405/02/2014103.57%0000000000
      11640406/02/2014103.57%0000000000
      11640423/12/2014320078.57%100.00%100.00%100.00%100.00%100.00%100.00%100.00%100.00%100.00%70.97%
      11640424/12/20141000000000003.22%
      11640425/12/20141000000000003.22%
      11640426/12/20141000000000003.22%
      11640427/12/20141000000000003.22%
      11640405/01/2015916.10%000000000012.88%
      11640501/01/201413.22%00000000000

       

      Regards