convert to datetime

Hello,

I need help with a formula to convert a field with 5/5/2017 12:31 to a datetime, how can I do this please?

That looks like it already is a Date and Time..
If that is stored as a text string, then you can simply add 0 to convert it to numerical date/time.
=A1+0

Thanks for the reply, how do I convert it into a format that would be recognized as a datetime in a sql db?

Originally Posted by Richard Buttrey

Hi and welcome to the forum.

Are you sure it isn't already a date.time number
Have you tested it with an =ISNUMBER(A1) to see if you get the answer TRUE

That value is True... Problem I am having is when I import the column into a db I get 00-00-0000

Maybe you need the opposite, and have it converted from real date/time into a text string.

Try
=TEXT(A1,"m/d/yyyy hh:mm")

Originally Posted by Jonmo1

Maybe you need the opposite, and have it converted from real date/time into a text string.

Try
=TEXT(A1,"m/d/yyyy hh:mm")

Jonmo1 that certainly makes sense to me, but it did not work. I think if I just cut off the time and just use date I will be good, is there a formula for that? I can simply format to be a date, but I think it still leaves the time in there as well.

To return the date only without the time

This returns as an actual date value.
=INT(A1)

This will return a date TEXT string
=TEXT(A1,"m/d/yyyy")