14 Replies Latest reply: Nov 5, 2015 7:53 AM by Chanty 4u RSS

    RE:Data showing

    Chanty 4u

      Hi all,

       

      I have date field like Start date and year weekend date like,

       

       

      LOAD

          PROJ_ID,

          //PROJ_SHORT_NAME,

          //DESCRIPTION,

          TASK_CODE,

          //TASK_NAME,

          RSRC_NAME,

          RSRC_SHORT_NAME,

          STARTDATE,

          Year(STARTDATE) as Syear,

          Month(STARTDATE) as Smonth,

           Date(STARTDATE) as Sdate,

          WeekEnd(STARTDATE) as WeekEndDate,

          ENDDATE,

          REMAININGUNITS

      FROM [lib://Qvdsource/p6_forecast_rsrc_spread.qvd]

      (qvd);

       

      when i go to front end date field is shwng like 41816 ..and  my strt date is  08-jan-2015 but in frnt end ...weekend data is shwng frm 28-jun-2014....evn i dnt hve data for 2014

      help me out

       

      thanks in advance

      suresh