The calculation should look similar to the following:
date(right(str([ACCGDTE]), 2) + "/1/" + left(str([ACCGDTE]), 4))
Hope this helps!
Thanks for your quick response
Your solution is only giving me the year not the month, which is the same solution that I got when I followed the date type conversion on one of tableau's tutorial. I would like to display the year and the month as a dimension.
Do you mean that when you place the calculation on the rows or columns shelf, only Year(Calculation) appears? If so, right click on this blue (or green) field and there will be more options for different date segments. (http://onlinehelp.tableausoftware.com/current/pro/online/en-us/help.htm#dates_levels.html )
If this is not what you're referring to can you post a screenshot or a packaged workbook (twbx file)?
Under the <More> option I was able to create a custom YYYYMM