Discussion board where members can get started with QlikView.
I am trying to convert a date that is formated as "YEARWEEKDAY" to "Year-MONTH-DAY" can anyone help me please!
Use MakeWeekDate() funcrtion
Hope it helps
Try using the below expresion
Hope this helps you.
You may also use the following expression:
date((Your_Date_Field_Name),'YYYY-MMM-DD') as NewDate
For example, if your date field has 22-04-2012, the above express will give 2012-APR-22.
Hope this helps.