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?
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
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
Richard Buttrey
RIP - d. 06/10/2022
If any of the responses have helped then please consider rating them by clicking the small star icon below the post.
Thanks for the reply, how do I convert it into a format that would be recognized as a datetime in a sql db?
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")
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")
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks