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.
@DanielCarro One way of doing this. The dd/mm/yyyy formatted can be converted into alteryx datetime format using the DateTimeParse() function and the numeric part can be converted using the toDate() function.
@DanielCarro, another way of doing this. Assuming there are many ways of entering the date. Everytime you have a different date format you can match the regex first then parse the date in alteryx date format.
if REGEX_Match([Date],"\d+") then ToDate(tonumber([Date])) elseif REGEX_Match([Date],"\d+/\d+/\d+") then DateTimeParse([Date],"%d/%m/%Y") else [Date] endif