-
1. Re: Converting mmm-yy to grouped date format
Joshua Milligan Jan 13, 2013 1:06 PM (in response to Paul Carysforth)I think you'll need to write a calculated field to convert the string "Jan-11" into a date.
It would look something like this:
Date(Replace([Date], "-", "-01-"))
That will convert Jan-11 to the date 01/01/2011.
I've attached a packaged workbook to demonstrate. In the future, please attach a workbook, or at least some data (dummy data) in excel format to questions. Thanks!
Just a note, the Replace function will only work with Excel if you are using an extract. Otherwise you'll need to use other string functions (such as Mid) to break apart and reconstruct the string into the date.
Joshua
-
Date Calculation.twbx.zip 39.9 KB
-
-
2. Re: Converting mmm-yy to grouped date format
Paul Carysforth Jan 13, 2013 1:16 PM (in response to Joshua Milligan)Hi Joshua,
Thanks for the quick reply and the guidance.
Will make sure I attach a doc next time.
Cheers
Paul
-
3. Re: Converting mmm-yy to grouped date format
Alex Kerin Jan 13, 2013 5:39 PM (in response to Paul Carysforth)1 of 1 people found this helpfulIt also sounds like you need to shape your data so date is in one column.http://kb.tableausoftware.com/articles/knowledgebase/preparing-excel-files-analysis