Date format in CSV errors
I'm testing Google Data Studio as an alternative reporting tool. I've implemented multiple data sources (GA, AdWords, Search Console) and so far so good. Now i'm trying to import third party data (FB) into datastudio and this is where it's getting complicated for me. I've created a CSV file in google sheets a long with the correct format of the dates (YYYYMMDD)
However, when setting the correct format type for the date field, i keep getting the following error:
So I click continue, but i do not know how to correct this error. For scorecards and tables i can receive some output but this is the total amount (summed) of the values inside the CSV file. So the problems clearly lies with the date format, but when I upload the same CSV file into Analytics (cost import) with the same date format no problems occur.
I tried different kind of date formats, and even used text as a format type but this not seems to help me that much.e
Does anyone knows how to fix it?