Convert YYYY-WW to Date

[#1]

Hello,

Is it possible to convert a YYYY-WW date format into a single date? Lets say the last day of that week?

[kaushiknsolanki]

Ralf,

.

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.

Regards,

Kaushik Solanki

[jagan]

Hi,

Try like this

=MakeWeekDate(left('2013-02',4), Num(SubField('2013-02', '-', 2)))

Regards,

Jagan.

[rbecher]

Or subfield:

=MakeWeekDate(subfield('2013-2','-',1),subfield('2013-2','-',2),0)