Date format

[#1]

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

[kaushiknsolanki]

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