DataFormatError

[Anonymous]

Hi,

in my table, I have 3 columns as shown below, I already set datatype's of Dataset as text, Date as date/Time and Country as Text.

Dataset    Date                         Country 

ABC      01/01/2020 00:00:00    Austria

BCD      01/01/2020 00:00:00    Belgium

CDE      02/01/2020 01:00:00    Denmark and so on.....

Later When I am trying to filter the dataset column, it gives me an error saying,  [DataFormat.Error] We couldn't parse the input provided as a DateTime value. I dont understand why is this, even though the datatype of dataset is text!! It would be great if anyone can suggest anything.

TIA

[v-xulin-mstf]

Hi @Anonymous,

According to the error messages, you can check the format of Date column.

If the issue still exist, please provide more details, such as sample data, screen shots, etc.

Best Regards,

Link

[PC2790]

Hello,

Can you please brief on the steps that you are doing when you say -trying to filter?

A screenshot would be helpful