Advertisements
In the event this question has (indeed) been asked before …my apologies (still learning how to use StackOverFlow)
Please let me know if there’s a Google/Spreadsheet "Function" that will provide a DD/MM/YYYY HH:MM:SS (readable) "Date" value into Column "B"?
I think the format is Json (not sure) …I’ve copied the date column into a "forum friendly" Google Sheet
Link to Google Sheet with Date "Column"
>Solution :
You may try:
=map(A2:A,lambda(Σ,if(Σ="",,epochtodate(--regexextract(Σ,"\d{10}")))))
- format the column to required date format accordingly