This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
Josh's formula works DateTimeParse([Raw Date], "%b %d %Y") or you can use the DateTime tool as well but there's no way to convert the date in that format to a date using the select tool you have to format it first.
For the DateTime tool you'd just select convert string to date time format and select the Raw Date field as the field you want to convert. Then select Custom for the format of the incoming string field and enter the following Mon dd yyyy and that will get your date output.
Sorry for the delayed reply, I didn't see this comment, can you provide some more sample data, I'm guessing the issue is that the month and day values aren't consistently 2 characters which will require some additional work to parse out and then convert to date format. If all the data is YYMMDD then you should be able to just use the Date conversion tool and set the input to that format and then use a second tool to convert the date field to whatever output you want.