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

[Anonymous]

you can change the format of your End Date Field like:

Date(EndDate,'DD-MMM-YYYY') as EndDate..

For 2014 post the sample data.

[Chanty4u]

but am getting error while usng the above date field

PFA  ..

in frnt end filterpane showng date format as 41816 lik dat

thanks

[Anonymous]

Have you done it at script level?

I done have QlikSense, not be able to QVF.

If you can share QVW or qvd?

[Chanty4u]

these all my qvds.

PFA

[Anonymous · Accepted solution]

PFA..

[Chanty4u]

thanks balraj..its wrkng fine

[Anonymous]

[Chanty4u]

but the date of 2014 is showng even i dont hve 2014 in my actual data ...?

[Anonymous]

which field and which qvd?