Hello, there's a problem using DateTime filter with the RadzenDataFilter component using ToODataFilterString method. I get an error "System.FormatException: 'String '24/07/2023 19:15:40' was not recognized as a valid DateTime." when I try to use it.
I'm in Italy and, as you can see, here the DateTime format differ from the one that CultureInfo.InvariantCulture produces. So, the lines of code:
1317 var value = $"{filter.FilterValue}";
and
1333 value = $"{DateTime.Parse(value, CultureInfo.InvariantCulture, System.Globalization.DateTimeStyles.RoundtripKind).ToString("yyyy-MM-ddTHH:mm:ss.fffZ")}";
in the file Radzen.QueryableExtension are inconsistent becouse the first uses the local format, while the second uses the CultureInfo.InvariantCulture, producing the error.
I think that a solution could be to introduce a line of code:
value = Convert.ToDateTime(filter.FilterValue).ToString(CultureInfo.InvariantCulture);
immediately before the line 1333.
I would have liked to make a pull request on GitHub but I'm not so good with it:-)
Thank you very much.