I have a field of date data in string format for week/year where the format is ww.yyyy (eg: 26.2016). This isn't a standard format in the DATEPARSE function. Does anyone have any idea to convert this string to a date?
I appreciate any help you can give.
Split by dot, convert year to date (DATE(STR([Year])+ "/1/1") then add weeks with DATEADD.
Become a Viz Whiz on the Forums!
Support the Community and master Tableau.
Retrieving data ...