topic Re: Date Format. in QlikView

Date Format.

deepakqlikview_123 — Fri, 13 Mar 2015 11:55:18 GMT

Hi All,

My date is in below format.

16589

16590

16591

16594

16595

16596

Can you please suggest how to extract month and year from this.

thanks

PrashantSangle — Fri, 13 Mar 2015 11:57:03 GMT

Hi,

Simply use Month(),MonthName(),Year() on that dateField

Regards

PrashantSangle — Fri, 13 Mar 2015 11:57:57 GMT

Hi,

Try like,

Month(DateField) as Month,

Year(DateField) as Year

Regards

iliyansomlev — Fri, 13 Mar 2015 11:58:06 GMT

year(date(16589)) or year(16589)

num(month(date(16589))) or month(16589)

you can do this in the model or in the visualization layer

Cheers,

Iliyan

rbecher — Fri, 13 Mar 2015 12:11:51 GMT

Hi Deepak,

is it of format DDMYY?

=Date(Date#(Text(MyDateField),'DDMYY'))

To cover both formats DDMYY and DDMMYY you can use this expression:

=Date(Date#(MyDateField, If(Len(Text(MyDateField))=5, 'DDMYY', 'DDMMYY')))

- Ralf