String to Date Transform

tableaucommunity@tableau.com — Wed, 30 May 2012 11:53:34 GMT

My input data for date is in this form: 'DDMMMYYYY' for example '10JAN2012'. I have tried the following calculated variable definition to transform to recognized date field:

DATE(
LEFT([date_var], 2) +
"-" +
MID([date_var], 3, 3) +
"-" +
RIGHT([date_var], 2)
)

I get null value.

I'm thinking it might have to do with my MMM piece being all caps. If so, is there a function to transform case of string data? (go from JAN to Jan?)

Thanks,

Kirk

Content in Tableau Community Forums

String to Date Transform