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 originally had a string field in a column as 04/27/2019, when converting from string to date using the DateTime tool, the column now shows the cell formatted as 2019-04-27. How can I format the date field of 2019-04-27 to 04/27/2019?

Well, you can use DateTime Tool to convert back from date type to string showing 04/27/2019 - but you end up having the same result. Are you looking to check if he incoming date is a valid DateTime format?