Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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.
You want to convert it into date or YYYY/WW??
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.
Thank you - worked great!