RE:Data showing

[Chanty4u]

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

[Chanty4u]

weekenddate is the field for except task and prjct qvds  as i mentioned above qvds

[Anonymous]

In shared QVW, I dont have 2014...u can chk that as well

[Anonymous]

in this Qvd p6_actuals_RSRC_SPREAD.qvd you are having 2014 data

[Anonymous]

In this as well

p6_planned_RSRC_SPREAD.qvd

[Chanty4u]

thank you

got it.