[Solved] convert radgrid field to date

[Kevin]

I have a date that I pull into my radgrid that I need to then convert to datefield so that I can color code them but whatever i do it never seems to work.  how can I change this string to date.

Protected Sub myRadGridList_ItemDataBound(sender As Object, e As Telerik.Web.UI.GridItemEventArgs) Handles myRadGridList.ItemDataBound
       If TypeOf e.Item Is GridDataItem Then
           Dim Item As GridDataItem = CType(e.Item, GridDataItem)
           Dim DOB As DateTime = DateTime.Parse(Item.Cells(2).Text.ToString)

           If DatePart(DateInterval.Month, DOB) = DatePart(DateInterval.Month, Date.Now) Then
               Item.Cells(2).ForeColor = Drawing.Color.Firebrick
           End If
       End If
   End Sub

[Jayesh Goyani]

Hello,

Please use Culture to convert string to datetime.

For Ex:

var dateString = "20081119";
var enUS = new System.Globalization.CultureInfo("en-US");
var resultingDate = DateTime.ParseExact(dateString,"yyyyMMdd",enUS);
Console.WriteLine(resultingDate.ToString());

Thanks,
Jayesh Goyani

[Princy]

Hi,

The column index starts at index 2 because GridExpandColumn and GridRowindicatorColumn are always in front of data columns. So please make sure that you are accessing the correct column. One suggestion is to use the UniqueName property to access the cell.

VB:

Protected Sub myRadGridList_ItemDataBound(sender As Object, e As Telerik.Web.UI.GridItemEventArgs) Handles myRadGridList.ItemDataBound
 If TypeOf e.Item Is GridDataItem Then
  Dim Item As GridDataItem = CType(e.Item, GridDataItem)
  Dim cell As TableCell = DirectCast(Item("UniqueName"), TableCell)'Accessing the cell using the UniqueName
   . . .
   . . .
 End If
End Sub

You can perform the DateTime conversion as Jayesh suggested.

Thanks,
Princy.