Can't convert to date

Post Reply
darxknight
Posts: 1
Joined: Sun Aug 15, 2021 9:46 am

Can't convert to date

Post by darxknight »

"Can't convert to date
Data Studio can't convert tgl_awal_ppk (Text) to a Date or Date & Time because it doesn't recognize the date format.

Possible solutions:
Change your data to use a supported format
Create a calculated field to convert tgl_awal_ppk to a valid date. For example, to convert "202011" to a date consisting of year and month:
Example: PARSE_DATE("%Y%m", tgl_awal_ppk)"

I've tried several date formats like Y-m-d,Ym,Ymd but it still doesn't work
Post Reply