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.