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.
Date Calculation.twbx.zip 39.9 KB
Thanks for the quick reply and the guidance.
Will make sure I attach a doc next time.