Unfortunately my data source has a "date" field that is text with the following format, ie, October 15, 2012.
How do I make this into a date? I think it would be easier if the Month was standard 3 letters across the board so I could do something to the effect of: date(date#('date', 'MMM/DD/YYYY')) as New_Date but it doesn't seem to work.
Any suggestions? Do I need to nest a ton of left, mid, rights, find(","), etc? Thanks so much.