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
Thanks for the reply, how do I convert it into a format that would be recognized as a datetime in a sql db?
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 iconbelow the post.
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