I have a date field in google sheets that is formatted as a date fiels YYYY-MM-DD. I download this as xlsx to then use as a data source in Studio Pro. This date field surfaces as a 6 digit number- what formula can I use to convert to date?
I tried
PARSE_DATE("%y%m%d", CAST(Month AS TEXT) )
But this gives me an error. Could someone supply the correct formula?
Thanks
User | Count |
---|---|
5 | |
1 | |
1 | |
1 | |
1 |