I am trying out the AI features using a trial account so i uploaded some of our data in the form of CSV files but for some reason no matter what format the dates are in I cannot get the CSV import to see them as dates meaning I can't create any visuals with a date

Hi Chris, Thanks for reaching out, are you able to share what date dimensions you are currently using. Also, kindly share what this looks like via screenshots to give us a clearer understanding of what you are currently working on.

Here is a couple of screenshots showing the data mapping the CSV import and the error when I try to use date in teh view by field

Hi Chris, Thanks for sharing the screenshots. After reviewing them, it looks like the issue may be related to how the date field is defined in your dataset. Currently, the date appears to be stored as a string rather than as a date or timestamp data type, which is required for correct handling in GoodData. This mismatch can cause errors during report creation or data transformations, especially if the platform expects a proper date format (as outlined in the GoodData documentation). If this issue persists after changing the date definition, kindly provide a CSV extract for us to test this and possibly find the root cause.

I have DMed you

Hi Chris, Thank you for sharing your dataset. I noticed that several of the date columns contain NULL values. This may be affecting how the CSV importer processes the data. Specifically, when a column has a mix of valid date entries and NULL values, the importer may default to treating the entire column as a string instead of a date type. This can happen if it’s unable to consistently recognize all values in the column as valid dates. To help ensure these columns are correctly recognized as dates, I recommend: Ensuring all date values follow a consistent format (e.g., YYYY-MM-DD) as shown in the documentation I shared earlier. Replacing NULL with a placeholder that’s still considered a valid date or leaving it completely empty. Let me know if you'd like help with any of these steps!

I will give those a try