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.
I'm encountering a situation where an excel spreadsheet will have a date column that may be formatted in a variety of ways. For example, the column may have dates formatted like this, depending on who fills out the spreadsheet:
It seems that the DateTime conversion tool is only useful if you already know the format ahead of time. Otherwise, I would have to build a workflow that would include a DateTime conversion tool for every conceivable date time format. Is there a combination of other tools that might be able to accomplish this?