This is a migrated thread and some comments may be shown as answers.

Radgrid Date column swapped century and year values 2015 as 1520

0 Answers 45 Views
Filter
This is a migrated thread and some comments may be shown as answers.
Subhashini
Top achievements
Rank 1
Subhashini asked on 03 Apr 2015, 06:51 PM

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.

 

 

 

 

 

 

No answers yet. Maybe you can help?

Tags
Filter
Asked by
Subhashini
Top achievements
Rank 1
Share this question
or