Converting from specific datetime format

[#1]

Hello,

I have this time format

Jul 31, 2017 4:00 AM

How can I convert it so that it is easier to work with?

I tried with to read it with Timestamp# and Date# but did'nt work out.

Thanks.

[tresB]

[sunny_talwar]

I would suggest adding a floor function to avoid any time component of the timestamp in the date field

=Date(Floor(Date#('Jul 31, 2017 4:00 AM', 'MMM DD, YYYY h:mm TT')))