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
