Convert text Date format 'Week WW YYYY' to Weekname YYYY/WW

[mazacini]

Hi

I have a text field in the format Week 13 2015

I want to convert it into a date format.

Any ideas?

Thanks

Joe

[sunny_talwar]

You want to convert it into date or YYYY/WW??

[swuehl · Accepted solution]

This will give you the weekstart date:

=MakeWeekDate(subfield('Week 13 2015',' ',3),subfield('Week 13 2015',' ',2))

edit:

From the weekstart date, you can create any format you like, using Weekname(), Week() and WeekYear() function.

[mazacini]

Thank you - worked great!