Regex - Convert ISO date string to DateTime | #Short

In this tip, We are going to explore:
Regex - Convert ISO date string to DateTime.
All explanations are simple and to the point.

#Shorts #GoogleForEducation #GoogleWorkspace #GoogleSheets

Feel free to make your copy of this spreadsheet (Sheet 12):

If you found this video helpful, give us an old like and share it with some people you think this could be helpful for. And if you're not already a subscriber, make sure to hit the subscribe button and also the notification bell to be notified every time a video is uploaded

Useful Link:
Google Workspace Tutorial:

Ben Collins (Google Developer Expert & Data Analytics Instructor)

Google Sheets training:

The Playlist link:

Follow us on Pinterest:

The tip inspired from:

We use this formula to extract the date and time.
REGEXREPLACE(A1, "(\d{4}-\d{2}-\d{2}).(\d{2}:\d{2}).+","$1 $2" )
Four digits then a hyphen.
Two digits then a hyphen.
Two digits.
Here is the first group.
Any one character.
Two digits, the colon, then two digits.
Here is the second group.
One or more of any character.
The first captured group.
The Second captured group.
Finally, we use the VALUE function.
VALUE(B1)