I think you can create a new date in your Workbook now by Changing Data type from String to Date and use it for your purpose.
That does not work now that this is an online data extract. If i right click the dimension/measure, i am not given the option to change the data type. Even if i go into the data source tab. How do I get around this?
Duplicate That Dimension, You should then get Change Data type option