Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Connect 2026! Turn data into bold moves, April 13 -15: Learn More!
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Stuck with Date Formats any help on this

Can any help on Date Function i am having date column with below format

LastReload
201501

as YYYYMM while using QlikView Chart objects to get Year,Month,Quarter how to achieve from this?

while using in Monthname(LastReload)=>Giving output as Sep 2451 actually expected is Jan 2015?

How to get MonthName(Jan,Feb,Mar....),month(1,2,3,4,5,6....),Quarter(2014Q4,2015Q1,2015Q2,2015Q3,...) all are expected from single Column LastReload

10 Replies
Colin-Albert
Partner - Champion
Partner - Champion

This post and the linked Technical Brief on Dates has a clear explanation of date formatting in QlikView

http://community.qlik.com/blogs/qlikviewdesignblog/2012/06/07/get-the-dates-right