Date

[smilingjohn]

Hi Expertise

Please find the attachment of qlikview file and excel .

I have created date and other dates

I need to show the week end date and week start date as two separate fields from Created .

Please someone help me on this

Thanks in advance

[andrey_krylov]

Like this?

[Anonymous]

Hi,

Try this

"Test:

LOAD Severity,

     Status,

     date(Created,'DD/MM/YYYY') as Created,

     Week(Created) as Week,

     Resolved,

     Closed

FROM

(ooxml, embedded labels, table is Sheet1);

Load*,

date(WeekEnd(Created),'DD/MM/YYYY') as WeekEndDate,

date(Weekstart(Created),'DD/MM/YYYY') as WeekstartDate

Resident Test;

drop Table Test "

[chakiw5]

Is it like this?