3 Replies Latest reply: Jul 11, 2013 2:36 AM by som niroula RSS

    source???

      i am woundering how to learn about script or change in the script.is there any source i can know about the script.when i do CTRL+E.Im stuck in the making my

      1. Orders with in last 30 days
      2. Orders between 31- 60 days
      3. Orders between 60 - 90 days
      4. Orders between 90 - 180 days
      5. Orders 180 and beyondand
      6. my script looks lik this right now

        CustomerID,

           EmployeeID,

           OrderDate,

           Year(OrderDate)as OrderYear,

           'Q' & Ceil(Month(OrderDate)/3) as Quarter,

           Dual('Q' & Ceil(Month(OrderDate)/3) & '-' & Year(OrderDate),

           Year(OrderDate) & Ceil(Month(OrderDate)/3)) as QtrYear,

           RequiredDate,