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.
