topic extract day from date field not working in QlikView

extract day from date field not working

Anonymous — Wed, 31 May 2017 18:12:22 GMT

ETLCal:

Load *,

Day(New_Date) as tmp_day

Day([To Date]) as tmp_day2,

;

LOAD [Loading Date],

[From Date],

[To Date],

Date#([To Date]) as New_Date,

Status

FROM $(vCalendarPath)

(txt, utf8, embedded labels, delimiter is ',', msq)

// where match(Day([To Date]),28,29,30,31)

;

I am unable to extract day from the date field. I tried typecasting the field and converting it to a set date format but no luck.

Would be really helpful if someone can look at this issue.

I have attached the calendar csv I am using to pull the dates from.

m_woolf — Wed, 31 May 2017 18:17:59 GMT

You need a comma after temp_day and remove the comma after temp_day2

vishsaggi — Wed, 31 May 2017 18:19:33 GMT

Try this?

LOAD [Loading Date],

[From Date],

[To Date],

Day(Date(Date#([To Date], 'M/DD/YYYY'), 'MM/DD/YYYY')) AS Day,

Status

FROM

[..\Desktop\iPowerCalendar.csv]

(txt, codepage is 1252, embedded labels, delimiter is '\t', msq);

Anonymous — Thu, 01 Jun 2017 18:22:49 GMT

Thanks. This worked