net 6.0 DateOnly model C1Json Error

Posted by: jungdh on 19 March 2022, 9:13 pm EST

  • Posted 19 March 2022, 9:13 pm EST

    Hello.

    After the net 6.0 migration, the DateTime type was changed to DateOnly.

    However, when C1Json is called, the following error occurs.


    Stack overflow.
    at Interop+Globalization.StartsWith(IntPtr, Char*, Int32, Char*, Int32, System.Globalization.CompareOptions, Int32*)
    at System.Globalization.CompareInfo.IcuStartsWith(System.ReadOnlySpan`1<Char>, System.ReadOnlySpan`1<Char>, System.Globalization.CompareOptions, Int32*)
    at System.Globalization.CompareInfo.IsPrefix(System.String, System.String, System.Globalization.CompareOptions)
    at C1.Web.Mvc.Serialization.BaseWriter+<>c__DisplayClass11_0.<WriteMemberInfoWithResolver>b__0(C1.Web.Mvc.Serialization.BaseResolver)
    at System.Linq.Enumerable.TryGetFirst[[System.__Canon, System.Private.CoreLib, Version=6.0.0.0, Culture=neutral, PublicKeyToken=7cec85d7bea7798e]](System.Collections.Generic.IEnumerable`1<System.__Canon>, System.Func`2<System.__Canon,Boolean>, Boolean ByRef)
    at C1.Web.Mvc.Serialization.BaseWriter.WriteMemberInfoWithResolver(System.Object, System.Object)
    at C1.Web.Mvc.Serialization.BaseWriter.WriteComplex(System.Object, System.Object, Boolean)
    at C1.Web.Mvc.Serialization.BaseWriter.WriteMemberValueWithScope(System.Object, System.Object, C1.Web.Mvc.Serialization.BaseConverter, Boolean)
    at C1.Web.Mvc.Serialization.BaseWriter.WriteMemberInfoWithoutResolver(System.String, System.Object, System.Object)
    at C1.Web.Mvc.Serialization.BaseWriter.WriteMemberInfoWithResolver(System.Object, System.Object)
    at C1.Web.Mvc.Serialization.BaseWriter.WriteComplex(System.Object, System.Object, Boolean)
    at C1.Web.Mvc.Serialization.BaseWriter.WriteMemberValueWithScope(System.Object, System.Object, C1.Web.Mvc.Serialization.BaseConverter, Boolean)
    at C1.Web.Mvc.Serialization.BaseWriter.WriteMemberInfoWithoutResolver(System.String, System.Object, System.Object)
    at C1.Web.Mvc.Serialization.BaseWriter.WriteMemberInfoWithResolver(System.Object, System.Object)
    at C1.Web.Mvc.Serialization.BaseWriter.WriteComplex(System.Object, System.Object, Boolean)
    at C1.Web.Mvc.Serialization.BaseWriter.WriteMemberValueWithScope(System.Object, System.Object, C1.Web.Mvc.Serialization.BaseConverter, Boolean)
    at C1.Web.Mvc.Serialization.BaseWriter.WriteMemberInfoWithoutResolver(System.String, System.Object, System.Object)
    at C1.Web.Mvc.Serialization.BaseWriter.WriteMemberInfoWithResolver(System.Object, System.Object)
    at C1.Web.Mvc.Serialization.BaseWriter.WriteComplex(System.Object, System.Object, Boolean)
    at C1.Web.Mvc.Serialization.BaseWriter.WriteMemberValueWithScope(System.Object, System.Object, C1.Web.Mvc.Serialization.BaseConverter, Boolean)
    at C1.Web.Mvc.Serialization.BaseWriter.WriteMemberInfoWithoutResolver(System.String, System.Object, System.Object)
    at C1.Web.Mvc.Serialization.BaseWriter.WriteMemberInfoWithResolver(System.Object, System.Object)
    at C1.Web.Mvc.Serialization.BaseWriter.WriteComplex(System.Object, System.Object, Boolean)
    at C1.Web.Mvc.Serialization.BaseWriter.WriteMemberValueWithScope(System.Object, System.Object, C1.Web.Mvc.Serialization.BaseConverter, Boolean)
    at C1.Web.Mvc.Serialization.BaseWriter.WriteMemberInfoWithoutResolver(System.String, System.Object, System.Object)
    at C1.Web.Mvc.Serialization.BaseWriter.WriteMemberInfoWithResolver(System.Object, System.Object)
    at C1.Web.Mvc.Serialization.BaseWriter.WriteComplex(System.Object, System.Object, Boolean)
    at C1.Web.Mvc.Serialization.BaseWriter.WriteMemberValueWithScope(System.Object, System.Object, C1.Web.Mvc.Serialization.BaseConverter, Boolean)
    at C1.Web.Mvc.Serialization.BaseWriter.WriteMemberInfoWithoutResolver(System.String, System.Object, System.Object)
    at C1.Web.Mvc.Serialization.BaseWriter.WriteMemberInfoWithResolver(System.Object, System.Object)
    at C1.Web.Mvc.Serialization.BaseWriter.WriteComplex(System.Object, System.Object, Boolean)
    at C1.Web.Mvc.Serialization.BaseWriter.WriteMemberValueWithScope(System.Object, System.Object, C1.Web.Mvc.Serialization.BaseConverter, Boolean)
    at C1.Web.Mvc.Serialization.BaseWriter.WriteMemberInfoWithoutResolver(System.String, System.Object, System.Object)
    at C1.Web.Mvc.Serialization.BaseWriter.WriteMemberInfoWithResolver(System.Object, System.Object)
    at C1.Web.Mvc.Serialization.BaseWriter.WriteComplex(System.Object, System.Object, Boolean)
    at C1.Web.Mvc.Serialization.BaseWriter.WriteMemberValueWithScope(System.Object, System.Object, C1.Web.Mvc.Serialization.BaseConverter, Boolean)
    at C1.Web.Mvc.Serialization.BaseWriter.WriteMemberInfoWithoutResolver(System.String, System.Object, System.Object)
    at C1.Web.Mvc.Serialization.BaseWriter.WriteMemberInfoWithResolver(System.Object, System.Object)
    at C1.Web.Mvc.Serialization.BaseWriter.WriteComplex(System.Object, System.Object, Boolean)
    at C1.Web.Mvc.Serialization.BaseWriter.WriteMemberValueWithScope(System.Object, System.Object, C1.Web.Mvc.Serialization.BaseConverter, Boolean)
    at C1.Web.Mvc.Serialization.BaseWriter.WriteMemberInfoWithoutResolver(System.String, System.Object, System.Object)
  • Replied 20 March 2022, 1:14 am EST

    my C1 AspNetCore version is 3.0.20213.330.

    [C1JsonRequest] CollectionViewBatchEditRequest Deserialize Error

    json datestring(yyyy-MM-dd) = System.String to System.DateOnly (error)
    json date(yyyy-MM-ddT00:00:00) = System.DateTime to System.DateOnly (error)
  • Replied 20 March 2022, 6:05 pm EST

    Hi,
    We are sorry for the inconvenience but we are unable to replicate the issue at our end, Please find the attached sample project. Please check with this and modify the sample depicting your issue so that we may investigate at our end.

    Regards,
    Manish Gupta

    FlexGrid_batchedit_c1json.zip
  • Replied 21 March 2022, 11:42 am EST

    based on sample source)
    License number 34: Changed DateTime Hired to DateOnly Hired.
    Line number 63: Change DateOnly.FromDateTime(DateTime.Today.AddDays(-_rnd.Next(1, 365))).

    If you run it after building, the following infinite error output occurs.


    Starting IIS Express ...
    Successfully registered URL "http://localhost:45432/" for site "FlexGridIntro" application "/"
    Registration completed for site "FlexGridIntro"
    IIS Express is running.
    info: Microsoft.AspNetCore.DataProtection.KeyManagement.XmlKeyManager[63]
    User profile is available. Using 'C:\Users\...\AppData\Local\ASP.NET\DataProtection-Keys' as key repository and Windows DPAPI to encrypt keys at rest.
    info: Microsoft.Hosting.Lifetime[0]
    Application started. Press Ctrl+C to shut down.
    info: Microsoft.Hosting.Lifetime[0]
    Hosting environment: Development
    info: Microsoft.Hosting.Lifetime[0]
    Content root path: D:\Downloads\FlexGrid_batchedit_c1json\FlexGridIntro
    info: Microsoft.AspNetCore.Hosting.Diagnostics[1]
    Request starting HTTP/1.1 GET http://localhost:45432/ - -
    info: Microsoft.AspNetCore.Routing.EndpointMiddleware[0]
    Executing endpoint 'FlexGridIntro.Controllers.HomeController.Index (FlexGridIntro)'
    info: Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker[3]
    Route matched with {action = "Index", controller = "Home"}. Executing controller action with signature Microsoft.AspNetCore.Mvc.IActionResult Index() on controller FlexGridIntro.Controllers.HomeController (FlexGridIntro).
    info: Microsoft.AspNetCore.Mvc.ViewFeatures.ViewResultExecutor[1]
    Executing ViewResult, running view Index.
    info: Microsoft.AspNetCore.Mvc.ViewFeatures.ViewResultExecutor[4]
    Executed ViewResult - view Index executed in 1015.9465ms.
    info: Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker[2]
    Executed action FlexGridIntro.Controllers.HomeController.Index (FlexGridIntro) in 1047.8791ms
    info: Microsoft.AspNetCore.Routing.EndpointMiddleware[1]
    Executed endpoint 'FlexGridIntro.Controllers.HomeController.Index (FlexGridIntro)'
    info: Microsoft.AspNetCore.Hosting.Diagnostics[2]
    Request finished HTTP/1.1 GET http://localhost:45432/ - - - 200 - text/html;+charset=utf-8 1259.7860ms
    info: Microsoft.AspNetCore.Hosting.Diagnostics[1]
    Request starting HTTP/1.1 GET http://localhost:45432/C1WebMvc/WebResources?r=GgLBAN0AwgDDAA%3D%3D - -
    info: Microsoft.AspNetCore.Routing.EndpointMiddleware[0]
    Executing endpoint 'C1.Web.Mvc.C1WebMvcController.WebResources (C1.AspNetCore.Mvc)'
    info: Microsoft.AspNetCore.Hosting.Diagnostics[1]
    Request starting HTTP/1.1 GET http://localhost:45432/_framework/aspnetcore-browser-refresh.js - -
    info: Microsoft.AspNetCore.Hosting.Diagnostics[1]
    Request starting HTTP/1.1 GET http://localhost:45432/C1WebMvc/WebResources?r=uABQAGgALABFACEADQBCAC0AugArAEEAtgCxAMAAtQAZALsAvACyAB0AHgAUAGEANQAzADQAPQA2ADkAOgA%2BABoAEwCHAAAA - -
    info: Microsoft.AspNetCore.Routing.EndpointMiddleware[0]
    Executing endpoint 'C1.Web.Mvc.C1WebMvcController.WebResources (C1.AspNetCore.Mvc)'
    info: Microsoft.AspNetCore.Hosting.Diagnostics[2]
    Request finished HTTP/1.1 GET http://localhost:45432/_framework/aspnetcore-browser-refresh.js - - - 200 11984 application/javascript;+charset=utf-8 128.5504ms
    info: Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker[3]
    Route matched with {action = "WebResources", controller = "C1WebMvc"}. Executing controller action with signature Microsoft.AspNetCore.Mvc.IActionResult WebResources(System.String) on controller C1.Web.Mvc.C1WebMvcController (C1.AspNetCore.Mvc).
    info: Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker[3]
    Route matched with {action = "WebResources", controller = "C1WebMvc"}. Executing controller action with signature Microsoft.AspNetCore.Mvc.IActionResult WebResources(System.String) on controller C1.Web.Mvc.C1WebMvcController (C1.AspNetCore.Mvc).
    info: Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker[2]
    Executed action C1.Web.Mvc.C1WebMvcController.WebResources (C1.AspNetCore.Mvc) in 98.9856ms
    info: Microsoft.AspNetCore.Routing.EndpointMiddleware[1]
    Executed endpoint 'C1.Web.Mvc.C1WebMvcController.WebResources (C1.AspNetCore.Mvc)'
    info: Microsoft.AspNetCore.Hosting.Diagnostics[2]
    Request finished HTTP/1.1 GET http://localhost:45432/C1WebMvc/WebResources?r=GgLBAN0AwgDDAA%3D%3D - - - 200 - text/css 321.1782ms
    info: Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker[2]
    Executed action C1.Web.Mvc.C1WebMvcController.WebResources (C1.AspNetCore.Mvc) in 210.5703ms
    info: Microsoft.AspNetCore.Routing.EndpointMiddleware[1]
    Executed endpoint 'C1.Web.Mvc.C1WebMvcController.WebResources (C1.AspNetCore.Mvc)'
    info: Microsoft.AspNetCore.Hosting.Diagnostics[2]
    Request finished HTTP/1.1 GET http://localhost:45432/C1WebMvc/WebResources?r=uABQAGgALABFACEADQBCAC0AugArAEEAtgCxAMAAtQAZALsAvACyAB0AHgAUAGEANQAzADQAPQA2ADkAOgA%2BABoAEwCHAAAA - - - 200 - text/javascript 410.0358ms
    info: Microsoft.AspNetCore.Hosting.Diagnostics[1]
    Request starting HTTP/1.1 POST http://localhost:45432/Home/RemoteBind_Read?_=3204 application/json 23
    info: Microsoft.AspNetCore.Routing.EndpointMiddleware[0]
    Executing endpoint 'FlexGridIntro.Controllers.HomeController.RemoteBind_Read (FlexGridIntro)'
    info: Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker[3]
    Route matched with {action = "RemoteBind_Read", controller = "Home"}. Executing controller action with signature Microsoft.AspNetCore.Mvc.ActionResult RemoteBind_Read(C1.Web.Mvc.CollectionViewRequest`1[FlexGridIntro.Person]) on controller FlexGridIntro.Controllers.HomeController (FlexGridIntro).
    Stack overflow.
    at Interop+Globalization.StartsWith(IntPtr, Char*, Int32, Char*, Int32, System.Globalization.CompareOptions, Int32*)
    at System.Globalization.CompareInfo.IcuStartsWith(System.ReadOnlySpan`1<Char>, System.ReadOnlySpan`1<Char>, System.Globalization.CompareOptions, Int32*)
    at System.Globalization.CompareInfo.IsPrefix(System.ReadOnlySpan`1<Char>, System.ReadOnlySpan`1<Char>, System.Globalization.CompareOptions)
    at System.Globalization.CompareInfo.IsPrefix(System.String, System.String, System.Globalization.CompareOptions)
    at System.String.StartsWith(System.String)
    at C1.Web.Mvc.Serialization.C1ClientEventResolver.CheckOnClientEventName(System.String)
    at C1.Web.Mvc.Serialization.C1ClientEventResolver.CanResolve(System.String, System.Object, System.Type, C1.Web.Mvc.Serialization.IContext)
    at C1.Web.Mvc.Serialization.BaseWriter+<>c__DisplayClass11_0.<WriteMemberInfoWithResolver>b__0(C1.Web.Mvc.Serialization.BaseResolver)
    at System.Linq.Enumerable.TryGetFirst[[System.__Canon, System.Private.CoreLib, Version=6.0.0.0, Culture=neutral, PublicKeyToken=7cec85d7bea7798e]](System.Collections.Generic.IEnumerable`1<System.__Canon>, System.Func`2<System.__Canon,Boolean>, Boolean ByRef)
    at System.Linq.Enumerable.FirstOrDefault[[System.__Canon, System.Private.CoreLib, Version=6.0.0.0, Culture=neutral, PublicKeyToken=7cec85d7bea7798e]](System.Collections.Generic.IEnumerable`1<System.__Canon>, System.Func`2<System.__Canon,Boolean>)
    at C1.Web.Mvc.Serialization.BaseWriter.WriteMemberInfoWithResolver(System.Object, System.Object)
    at C1.Web.Mvc.Serialization.BaseWriter.WriteMemberInfo(System.Object, System.Object)
    at C1.Web.Mvc.Serialization.BaseWriter.WriteComplexSubItem(System.Object, System.Object, Int32, Int32)
    at C1.Web.Mvc.Serialization.BaseWriter.WriteComplex(System.Object, System.Object, Boolean)
    at C1.Web.Mvc.Serialization.BaseWriter.WriteValue(System.Object, System.Object)
    at C1.Web.Mvc.Serialization.BaseWriter.WriteRawMemberValue(System.Object, System.Object)
    at C1.Web.Mvc.Serialization.BaseWriter.WriteMemberValueWithoutScope(System.Object, System.Object, C1.Web.Mvc.Serialization.BaseConverter)
    at C1.Web.Mvc.Serialization.BaseWriter.WriteMemberValueWithScope(System.Object, System.Object, C1.Web.Mvc.Serialization.BaseConverter, Boolean)
    at C1.Web.Mvc.Serialization.BaseWriter.WriteMemberInfo(System.String, System.Object, System.Object, C1.Web.Mvc.Serialization.BaseConverter)
    at C1.Web.Mvc.Serialization.BaseWriter.WriteMemberInfoWithSettings(System.String, System.Object, System.Object, C1.Web.Mvc.Serialization.BaseConverter)
    at C1.Web.Mvc.Serialization.BaseWriter.WriteMemberInfoWithoutResolver(System.String, System.Object, System.Object)
    at C1.Web.Mvc.Serialization.BaseWriter.WriteMemberInfoWithResolver(System.Object, System.Object)
    at C1.Web.Mvc.Serialization.BaseWriter.WriteMemberInfo(System.Object, System.Object)
    at C1.Web.Mvc.Serialization.BaseWriter.WriteComplexSubItem(System.Object, System.Object, Int32, Int32)
    at C1.Web.Mvc.Serialization.BaseWriter.WriteComplex(System.Object, System.Object, Boolean)
    at C1.Web.Mvc.Serialization.BaseWriter.WriteValue(System.Object, System.Object)
    at C1.Web.Mvc.Serialization.BaseWriter.WriteRawMemberValue(System.Object, System.Object)
    at C1.Web.Mvc.Serialization.BaseWriter.WriteMemberValueWithoutScope(System.Object, System.Object, C1.Web.Mvc.Serialization.BaseConverter)
    at C1.Web.Mvc.Serialization.BaseWriter.WriteMemberValueWithScope(System.Object, System.Object, C1.Web.Mvc.Serialization.BaseConverter, Boolean)
    at C1.Web.Mvc.Serialization.BaseWriter.WriteMemberInfo(System.String, System.Object, System.Object, C1.Web.Mvc.Serialization.BaseConverter)
    at C1.Web.Mvc.Serialization.BaseWriter.WriteMemberInfoWithSettings(System.String, System.Object, System.Object, C1.Web.Mvc.Serialization.BaseConverter)
    at C1.Web.Mvc.Serialization.BaseWriter.WriteMemberInfoWithoutResolver(System.String, System.Object, System.Object)
    at C1.Web.Mvc.Serialization.BaseWriter.WriteMemberInfoWithResolver(System.Object, System.Object)
    at C1.Web.Mvc.Serialization.BaseWriter.WriteMemberInfo(System.Object, System.Object)
    at C1.Web.Mvc.Serialization.BaseWriter.WriteComplexSubItem(System.Object, System.Object, Int32, Int32)
    at C1.Web.Mvc.Serialization.BaseWriter.WriteComplex(System.Object, System.Object, Boolean)
    at C1.Web.Mvc.Serialization.BaseWriter.WriteValue(System.Object, System.Object)
    at C1.Web.Mvc.Serialization.BaseWriter.WriteRawMemberValue(System.Object, System.Object)
    at C1.Web.Mvc.Serialization.BaseWriter.WriteMemberValueWithoutScope(System.Object, System.Object, C1.Web.Mvc.Serialization.BaseConverter)
    at C1.Web.Mvc.Serialization.BaseWriter.WriteMemberValueWithScope(System.Object, System.Object, C1.Web.Mvc.Serialization.BaseConverter, Boolean)
    at C1.Web.Mvc.Serialization.BaseWriter.WriteMemberInfo(System.String, System.Object, System.Object, C1.Web.Mvc.Serialization.BaseConverter)
    at C1.Web.Mvc.Serialization.BaseWriter.WriteMemberInfoWithSettings(System.String, System.Object, System.Object, C1.Web.Mvc.Serialization.BaseConverter)
    at C1.Web.Mvc.Serialization.BaseWriter.WriteMemberInfoWithoutResolver(System.String, System.Object, System.Object)
    at C1.Web.Mvc.Serialization.BaseWriter.WriteMemberInfoWithResolver(System.Object, System.Object)
    at C1.Web.Mvc.Serialization.BaseWriter.WriteMemberInfo(System.Object, System.Object)
    at C1.Web.Mvc.Serialization.BaseWriter.WriteComplexSubItem(System.Object, System.Object, Int32, Int32)
    at C1.Web.Mvc.Serialization.BaseWriter.WriteComplex(System.Object, System.Object, Boolean)
    at C1.Web.Mvc.Serialization.BaseWriter.WriteValue(System.Object, System.Object)
    at C1.Web.Mvc.Serialization.BaseWriter.WriteRawMemberValue(System.Object, System.Object)
    at C1.Web.Mvc.Serialization.BaseWriter.WriteMemberValueWithoutScope(System.Object, System.Object, C1.Web.Mvc.Serialization.BaseConverter)
    at C1.Web.Mvc.Serialization.BaseWriter.WriteMemberValueWithScope(System.Object, System.Object, C1.Web.Mvc.Serialization.BaseConverter, Boolean)
    at C1.Web.Mvc.Serialization.BaseWriter.WriteMemberInfo(System.String, System.Object, System.Object, C1.Web.Mvc.Serialization.BaseConverter)
    at C1.Web.Mvc.Serialization.BaseWriter.WriteMemberInfoWithSettings(System.String, System.Object, System.Object, C1.Web.Mvc.Serialization.BaseConverter)
    at C1.Web.Mvc.Serialization.BaseWriter.WriteMemberInfoWithoutResolver(System.String, System.Object, System.Object)
    at C1.Web.Mvc.Serialization.BaseWriter.WriteMemberInfoWithResolver(System.Object, System.Object)
    at C1.Web.Mvc.Serialization.BaseWriter.WriteMemberInfo(System.Object, System.Object)
    at C1.Web.Mvc.Serialization.BaseWriter.WriteComplexSubItem(System.Object, System.Object, Int32, Int32)
    at C1.Web.Mvc.Serialization.BaseWriter.WriteComplex(System.Object, System.Object, Boolean)
    at C1.Web.Mvc.Serialization.BaseWriter.WriteValue(System.Object, System.Object)
    at C1.Web.Mvc.Serialization.BaseWriter.WriteRawMemberValue(System.Object, System.Object)
    at C1.Web.Mvc.Serialization.BaseWriter.WriteMemberValueWithoutScope(System.Object, System.Object, C1.Web.Mvc.Serialization.BaseConverter)
    at C1.Web.Mvc.Serialization.BaseWriter.WriteMemberValueWithScope(System.Object, System.Object, C1.Web.Mvc.Serialization.BaseConverter, Boolean)
    at C1.Web.Mvc.Serialization.BaseWriter.WriteMemberInfo(System.String, System.Object, System.Object, C1.Web.Mvc.Serialization.BaseConverter)
    at C1.Web.Mvc.Serialization.BaseWriter.WriteMemberInfoWithSettings(System.String, System.Object, System.Object, C1.Web.Mvc.Serialization.BaseConverter)
    at C1.Web.Mvc.Serialization.BaseWriter.WriteMemberInfoWithoutResolver(System.String, System.Object, System.Object)
    at C1.Web.Mvc.Serialization.BaseWriter.WriteMemberInfoWithResolver(System.Object, System.Object)
    at C1.Web.Mvc.Serialization.BaseWriter.WriteMemberInfo(System.Object, System.Object)


    Thank you.

    FlexGrid_batchedit_c1json.zip
  • Replied 21 March 2022, 8:32 pm EST

    Hi,
    Thank you for sharing the updated sample. We have forwarded this issue to the concerned team for further investigation with the internal tracking id C1WEB-29002.


    We will let you know as we get an update on this.

    Regards,
    Mansih Gupta
  • Replied 24 March 2022, 3:48 am EST

    Hi,
    This issue is not with the C1 controls. It is with the JsonSerializer. A similar issue post has been found as follows:
    https://github.com/npgsql/efcore.pg/issues/1883

    Hence, please use the DateTime data type for Dates and format the column to show only the date.

    Regards,
    Manish Gupta
Need extra support?

Upgrade your support plan and get personal unlimited phone support with our customer engagement team

Learn More

Forum Channels