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.
my source date is from excel and loaded it to Alteryx. My date was 04/15/2019 but it become a string value of 43570 and cannot convert using the tool to date format. Alteryx says cannot convert "43570" to a date/time format. Please help!
Excel stores dates internally as offsets from 1899-12-30, so 43570 = 2019-04-15. Sometimes, usually with .xls, but some times with .xlsx files, Alteryx interprets the date as a number, or in your case a string. To convert it back to a date field use the following in a formula tool
@Maskell_Rascal was correct in the conversion, but the field has to be a number. The "ToNumber" in the formula converts the string to a number. It also works with fields that are already numeric.
The attached WF converts 43570 into the Date field 2019-04-15
Giving the result
Note: Alteryx stores all dates internally in the format YYYY-MM-DD