Discussion Board for collaboration on QlikView Scripting.
Is it possible to convert a YYYY-WW date format into a single date? Lets say the last day of that week?
Go to Solution.
In that case you can try this.
Use MakeWeekDate() function.
=MakeWeekDate(Left('2013-09',4),Right('2013-09',2),6) // the red '6' tells about the last day of the week, you can modify accordingly.
Yes. Consider that the YYYY-WW is the text then you can use the below expression to get the date.
Here 0 is considered as monday of that week.
Here is one option (vWeek should be a date in YYYY-WW format):
Thank you. I have one problem. Some fields are like this:
instead of 2013-02.
Is there a way to exclude the '-' ?
suggestion is not bad but num() will not work in this case, but num#() will work.
Yes there is:
Would be a negative week number:
MakeWeekDate(left('2013-2',4),Num#(right('2013-2',2)),0) => 10.12.2012
, right .