Re: Date Format. - Qlik Community

deepakqlikview_123 · ‎2015-03-13

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 · ‎2015-03-13

Hi,

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

Regards

Great dreamer's dreams never fulfilled, they are always transcended.
Please appreciate our Qlik community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved 🙂

PrashantSangle · ‎2015-03-13

Hi,

Try like,

Month(DateField) as Month,

Year(DateField) as Year

Regards

Great dreamer's dreams never fulfilled, they are always transcended.
Please appreciate our Qlik community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved 🙂

iliyansomlev · ‎2015-03-13

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 · ‎2015-03-13

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

Astrato.io Head of R&D