Date format

Tue, 26 Mar 2013 09:22:50 GMT

hi,

Am having a tab seperated file. Which has column named dated of timestamp format.

In qlik view i want month year and start week out of that column, the code am using is given below

Date(dated,'YYYY-MM-DD') as EntryDate,
Year(dated) as Year,
Date(MonthStart(dated),'YYYY-MM') as MonthYear,
QuarterName(QuarterStart(dated)) as QuarterYear,
Date(WeekStart(dated),'YYYY-MM-DD') as StartWeek;

When i run with this queries its fetching zero rows.

Awaiting your response.

Regards,

Teja.

P.S. - attachment

Re: Date format

kaushiknsolanki — Tue, 26 Mar 2013 09:32:53 GMT

Hi,

Try this.

Date(Date#(Dated,'YYYY-MM-DD')) as Date,

Year(Date(Date#(Dated,'YYYY-MM-DD'))) as year,

Month(Date(Date#(Dated,'YYYY-MM-DD'))) as Month

...

Regards,

Kaushik Solanki

topic Date format in QlikView

Date format

Re: Date format