dategoogle-sheets-formulastring-formattingspreadsheetgoogle-query-language
How can I format a string sheet to date with Query
I have a col on googlesheet, that I need convert to date time with query function.
| Column A | Column B |
|---|---|
| nome1 | 2022-11-17T13:41:47.431Z |
| name2 | 2022-11-17T13:41:47.431Z |
| Column A | Column B |
|---|---|
| nome1 | 2022-11-17 13:41:47 |
| name2 | 2022-11-17 13:41:47 |
Solution
try:
=INDEX(QUERY({A1:A, TEXT(REGEXREPLACE(B1:B,
"[TZ]", " "), "e-mm-dd hh:mm:ss")}))
- Trying to figure out why my GoogleSheets Date formula is not working
- How to convert date in to yyyy-MM-dd Format?
- Check if one date is between two dates
- How to retrieve the current day of the week?
- GWT get build date
- PHP date() with timezone?
- Comparing text fields that contain dates in Google Sheets
- Carbon and PHP DateTime parse single letters as dates, but not multi-character strings
- Detect daylight saving time in bash
- java.util.Date vs java.sql.Date
- Find all month names between two given date in java
- vba return first row number in column that has todays date or nearest date after today
- Iterate over all last-day-of-the-month dates in a year
- How to set the current date in the gnuplot title
- How can I validate a date in Python 3.x?
- how to use str_to_date (MySQL) to parse two-digit year correctly
- Jquery dd/MM/yyyy date format validation
- Duration between two dates in Ruby (Rails)
- How to generate a Date from just Month and Year in Java?
- In Swift 5, how do I increment a date property by some interval and then run the function with that new future date?
- Last day of quarter
- Split timeperiods by referring dates in another table
- for loop to generate time list in javascript
- Implementing range between dates in a window
- How to calculate difference between dates by group in SAS
- Why does DateTime.Now to the yyyy-mm-dd format give me incorrect month results?
- How to get current date and time in WordPress?
- Date change function in PHP
- Best approach to remove time part of datetime in SQL Server
- How to get year/month/day from a date object?