Is it possible to convert a YYYY-WW date format into a single date? Lets say the last day of that week?
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.
Thank you. I have one problem. Some fields are like this:
instead of 2013-02.
Is there a way to exclude the '-' ?
Yes there is:
Here is one option (vWeek should be a date in YYYY-WW format):
In that case you can try this.
suggestion is not bad but num() will not work in this case, but num#() will work.
Would be a negative week number:
MakeWeekDate(left('2013-2',4),Num#(right('2013-2',2)),0) => 10.12.2012
, right .
you are also right.
Better you use the solusion i have suggested with checking the lenth, you can also try the solution given by Ori.
Try like this
=MakeWeekDate(left('2013-02',4), Num(SubField('2013-02', '-', 2)))
Retrieving data ...