Data Format Mismatch Error

Ask for Help
1

Hi,

I am getting an error while connecting my large data set with Glide. As it’s showing- Data Format Mismatch.

However, I have followed data actual format of the data being retrieved and configured it with Glide. Also all the schema, field types, and data formats have been verified manually.

Is it due to this Format- ‘created_at’. Expected format: ‘YYYY-MM-DD HH:MM:SS’, Received format: ‘MM/DD/YYYY HH:MM:SS’."

In this Power BI job opportunities blog, there is a section talking about Date Format automatically convert with the given format and how can it be possible.

Any solution to this?

Thanks
Olivia

2

I’ve not seen that specific error before, but I can say that as a general rule it is much better to store all dates and times using the international standard (ISO8601) format. That is, YYYY-MM-DD HH:MM:SS.

The problem with using either DD/MM/YYYY or MM/DD/YYYY is that it can be ambiguous. For example, if you present the date as 03/09/2024, that could be interpreted as either the 3rd of September or the 9th of March.

1 Like
3

Let me try this with given format but do I need to change the format of existing data format, if yes then it might be time consuming, well let’s try.

4

How did you receive the date in the first place?

5

If using Glide Tables to store dates.

Worst case scenario, create a new column with Type > Computed > Experimental > Code > Javascript.

You can then code any simple JavaScript function to correct date format. It’s quite fast to do, depends your wrong date format.