Radgrid Date column swapped century and year values 2015 as 1520

1 posts, 0 answers
  1. Subhashini
    Subhashini avatar
    35 posts
    Member since:
    Oct 2014

    Posted 03 Apr 2015 Link to this post

    I followed the exact example as given in the demo - http://demos.telerik.com/aspnet-ajax/grid/examples/functionality/filtering/filter-templates/defaultvb.aspx?show-source=true

    When the radgrid is displayed, the date is given as 1/16/1520, see attached image.

    When tried to filter using the raddatepicker, it takes in the input as M/d/yyyy (e.g. 4/3/2015) format and gives the OracleSQL error "month not valid"

    I tried to set the date format in the radgrid_columncreated -

    CType(e.Column, GridBoundColumn).DataFormatString = "{0:MM\/dd\/yyyy}"

    CType(e.Column, GridBoundColumn).DataFormatString = "{0:d}"

    and other rad date formats. Still no luck.

    With the  rad filter template the date formats are wrong but with the basic filter or no filter the Radgrid is good.

     

     

     

     

     

     

Back to Top