Hello. The best way to get this – is to change cells format to “date” directly in spreadsheet (for all column), values will be converted automatically.
Other way – send formula:
=DATEVALUE("[_date]")
But in result you’ll get integer value, so you should convert cells to “date” format anyway.
Thank you very much for your kind and prompt reply.
Excuse one more question, before formatting, the data must come in string or number?
What happens is that the string data has an apostrophe character at the beginning which does not disappear when formatting the date.
It should work as string (with singlequote symbol).
I just tested:
1) Send date as usual string.
2) Select column, Format->Number->Date in menu
3) Value changes to 08/26/2020
Actually, if it works, the value changes when formatting is applied, however it does not change automatically despite having previously formatted the entire column, that is, I have to apply the format to the data so that they change.
Try to figure it out somehow with formulas (you can parse string and process it as date.
https://stackoverflow.com/questions/48839999/automatically-convert-date-text-to-correct-date-format-using-google-sheets
Maybe here some useful.
Sorry, nothing more I can help in this case.
Thank you very much for your help, I used formula and now everything is going very well!
