DataGrid filtering date column with dd.MM.yyyy format hiting exception

I am trying to implement DataGrid contol in Blazor app.
I did not set explicit culture in startup.cs, but looks like visual studio recognise that my threads are in European style of dates dd.MM.yyyy

On razor page with DataGrid I have date column.
Column rendering as regular date format (dd.MM.yyyy) on display,
But if user try to filter date column , browser hit exception.

Same thing hapening in Chorme and Firefox on Win10.

I do not get any exception inside visual studio,


Here is my Razor page Code
@page "/bo"
@inject Services.bo boServis;
@using Models.Bo;

@if (smjene == null)
{
    <p><em>Učitavam...</em></p>
}
else
{
    <RadzenGrid AllowFiltering="true" FilterCaseSensitivity="FilterCaseSensitivity.CaseInsensitive" AllowPaging="true" PageSize="10"  
                AllowSorting="true"
                Data="@smjene" 
                TItem="Smjene" 
                ColumnWidth="200px">
        <Columns>
            <RadzenGridColumn TItem="Smjene" Property="Datum" Title="Datum">
                <Template Context="data">
                    @String.Format("{0:d}", data.Datum)
                </Template>
            </RadzenGridColumn>
        </Columns>
    </RadzenGrid>
}

@code {
    List<Models.Bo.Smjene> smjene;

    protected override async Task OnInitializedAsync()
    {
        smjene = await boServis.smjene();
    }

}

Full Error
blazor.server.js:15 [2019-11-21T14:59:32.564Z] Error: System.FormatException: 20.11.2019 00:00:00 is not a valid value for DateTime.
 ---> System.FormatException: String '20.11.2019 00:00:00' 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)
   at System.ComponentModel.DateTimeConverter.ConvertFrom(ITypeDescriptorContext context, CultureInfo culture, Object value)
   --- End of inner exception stack trace ---
   at System.ComponentModel.DateTimeConverter.ConvertFrom(ITypeDescriptorContext context, CultureInfo culture, Object value)
   at System.ComponentModel.TypeConverter.ConvertFromInvariantString(String text)
   at System.Linq.Dynamic.Core.Parser.ExpressionParser.GenerateConversion(Expression expr, Type type, Int32 errorPos)
   at System.Linq.Dynamic.Core.Parser.ExpressionParser.ParseTypeAccess(Type type)
   at System.Linq.Dynamic.Core.Parser.ExpressionParser.ParseIdentifier()
   at System.Linq.Dynamic.Core.Parser.ExpressionParser.ParsePrimaryStart()
   at System.Linq.Dynamic.Core.Parser.ExpressionParser.ParsePrimary()
   at System.Linq.Dynamic.Core.Parser.ExpressionParser.ParseUnary()
   at System.Linq.Dynamic.Core.Parser.ExpressionParser.ParseMultiplicative()
   at System.Linq.Dynamic.Core.Parser.ExpressionParser.ParseAdditive()
   at System.Linq.Dynamic.Core.Parser.ExpressionParser.ParseShiftOperator()
   at System.Linq.Dynamic.Core.Parser.ExpressionParser.ParseComparisonOperator()
   at System.Linq.Dynamic.Core.Parser.ExpressionParser.ParseLogicalAndOrOperator()
   at System.Linq.Dynamic.Core.Parser.ExpressionParser.ParseIn()
   at System.Linq.Dynamic.Core.Parser.ExpressionParser.ParseAndOperator()
   at System.Linq.Dynamic.Core.Parser.ExpressionParser.ParseOrOperator()
   at System.Linq.Dynamic.Core.Parser.ExpressionParser.ParseLambdaOperator()
   at System.Linq.Dynamic.Core.Parser.ExpressionParser.ParseNullCoalescingOperator()
   at System.Linq.Dynamic.Core.Parser.ExpressionParser.ParseConditionalOperator()
   at System.Linq.Dynamic.Core.Parser.ExpressionParser.Parse(Type resultType, Boolean createParameterCtor)
   at System.Linq.Dynamic.Core.DynamicExpressionParser.ParseLambda(ParsingConfig parsingConfig, Boolean createParameterCtor, ParameterExpression[] parameters, Type resultType, String expression, Object[] values)
   at System.Linq.Dynamic.Core.DynamicExpressionParser.ParseLambda(ParsingConfig parsingConfig, Boolean createParameterCtor, Type itType, Type resultType, String expression, Object[] values)
   at System.Linq.Dynamic.Core.DynamicQueryableExtensions.Where(IQueryable source, ParsingConfig config, String predicate, Object[] args)
   at System.Linq.Dynamic.Core.DynamicQueryableExtensions.Where[TSource](IQueryable`1 source, ParsingConfig config, String predicate, Object[] args)
   at System.Linq.Dynamic.Core.DynamicQueryableExtensions.Where[TSource](IQueryable`1 source, String predicate, Object[] args)
   at Radzen.Blazor.RadzenGrid`1.get_View()
   at Radzen.Blazor.RadzenGrid`1.get_PagedView()
   at Radzen.Blazor.RadzenGrid`1.BuildRenderTree(RenderTreeBuilder __builder)
   at Microsoft.AspNetCore.Components.ComponentBase.<.ctor>b__6_0(RenderTreeBuilder builder)
   at Microsoft.AspNetCore.Components.Rendering.ComponentState.RenderIntoBatch(RenderBatchBuilder batchBuilder, RenderFragment renderFragment)
   at Microsoft.AspNetCore.Components.RenderTree.Renderer.RenderInExistingBatch(RenderQueueEntry renderQueueEntry)
   at Microsoft.AspNetCore.Components.RenderTree.Renderer.ProcessRenderQueue()
1 Like

What is your Radzen.Blazor version?

I did install it over Nu get ant it is on version v1.2.3

Issue reproduced. We will do our best to provide fix soon.

1 Like

I've just published Radzen.Blazor 1.2.4. Let me know how it goes!

1 Like

That was very fast, fastest then We cloud tested, Thanx a lot.

Data grid with date filter in format dd.MM.yyyy on version 1.2.4 working as should.