Problem with culture in date filter

Radzen.Blazor Components
1

Hi,

If I try to set a date filter on https://blazor.radzen.com/datagrid I get an exception:

image
image1933×1009 144 KB

My browsers language settings are:

image
image752×279 14 KB

I guess the reason is the formatting of the date.

I have the same problem in my own application.

Is there a way to avoid the problem?

2

You might have the same problem:

3

Unfortunately that did not fix the problem :frowning:

My application is working when i run it locally. The error occurs when it is running as a Web App in Azure. Then I get the following exeption:

blazor.server.js:1 [2023-07-05T08:57:10.961Z] Error: System.FormatException: String '2023-06-29T00.00.00.000Z' was not recognized as a valid DateTime.
   at System.DateTimeParse.Parse(ReadOnlySpan`1 s, DateTimeFormatInfo dtfi, DateTimeStyles styles)
   at System.DateTime.Parse(String s, IFormatProvider provider, DateTimeStyles styles)
   at Radzen.QueryableExtension.GetColumnFilter[T](RadzenDataGridColumn`1 column, String value, Boolean second)
   at Radzen.QueryableExtension.ToFilterString[T](IEnumerable`1 columns)
   at Radzen.Blazor.RadzenDataGrid`1.InvokeLoadData(Int32 start, Int32 top)
   at Radzen.Blazor.RadzenDataGrid`1.Reload()
   at Radzen.Blazor.RadzenDataGrid`1.OnFilter(ChangeEventArgs args, RadzenDataGridColumn`1 column, Boolean force, Boolean isFirst)
   at Radzen.Blazor.RadzenDataGrid`1.ApplyFilter(RadzenDataGridColumn`1 column, Boolean closePopup)
   at Radzen.Blazor.RadzenDataGridHeaderCell`1.ApplyFilter()
   at Microsoft.AspNetCore.Components.ComponentBase.CallStateHasChangedOnAsyncCompletion(Task task)
   at Microsoft.AspNetCore.Components.RenderTree.Renderer.GetErrorHandledTask(Task taskToHandle, ComponentState owningComponentState)

I am statically setting the culture with the following code:

app.UseRequestLocalization("da-DK");

I have tried with:

app.UseRequestLocalization(new RequestLocalizationOptions()
    .AddSupportedCultures("en-US")
    .AddSupportedUICultures("da-DK")
    .SetDefaultCulture("da-DK"));

Now it works in Azure but the name of the month in the date filter is in English instead of Danish :frowning: