Tableau cannot recognize timestamp field in my log file
<p>I am using Tableau 9.3 to do a preliminary data analysis on one of my log file, the log file is like below:</p>

<blockquote>
  <p>"199.72.81.55",01/Jul/1995:00:00:01,/history/apollo/,200,6245,Sat</p>
</blockquote>

<p>As you can see, there is a datetime for timestamp</p>

<p>In Tableau, initially it is recognized as a string like below:</p>

<p><a href="https://i.stack.imgur.com/m2KEt.jpg" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/m2KEt.jpg" alt="enter image description here"></a></p>

<p>That's fine, I want to make the field into datetime, and Tableau seems failed on it:</p>

<p><a href="https://i.stack.imgur.com/VJ0gX.jpg" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/VJ0gX.jpg" alt="enter image description here"></a></p>

<p>Why? How do I fix it?</p>

<p>Thank you very much.</p>

<p>UPDATED: after applying the formula suggested below, Tableau still cannot recognize the timestamp, here is the screenshot:</p>

<p><a href="https://i.stack.imgur.com/AJ1NF.jpg" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/AJ1NF.jpg" alt="enter image description here"></a></p>

<p>UPDATED AGAIN: after tested by nick, it is confirmed his first script is correct and working on his Tableau, why it fails on mine, I don't know, you are welcome to share any clue please, thank you.</p>