3 Replies Latest reply: Jan 11, 2013 10:22 AM by Travis Russo RSS

    Change text to date

    Travis Russo

      Hi all,

       

      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.