2 Replies Latest reply: Sep 8, 2014 11:42 AM by Colin Albert RSS

    create a calender using two date fields

      I would like to know how to create a calender using three date fields from same table?

       

       

      Budget:

      LOAD BUDGET_ENTITY,

           PROJ_MGR_RC,

          Date(CFAS_START_DATE, 'MM/DD/YYYY') AS CFAS_START_DT,
           Date(CFAS_EST_IN_SERVICE_DATE, 'MM/DD/YYYY') AS CFAS_EST_IN_SERV_DT,
           CFAS_CLOSED_DATE

      FROM

      Budget_details;

       

      I want to create a calender using the following columns.

      CFAS_START_DT
      CFAS_EST_IN_SERV_DT
      CFAS_CLOSED_DATE

       

      Thank You.