Getting date with time

[monikanimbalkar]

hello guys,

i retrieving only date from another excel using “row.item(“columnname”).tostring” but as i showed in above screenshot im getting date along with time which i don’t want.

thanks
cheers

[Pradeep_Shiv]

which column you want??
from above screenshot?

[supermanPunch (Arpan)]

@monikanimbalkar Check Using row(“columnname”).toString.Split()(0).toStirng.Trim

[Craig1]

Use DateTime.Parse() to convert the string to a .Net DateTime object, then get the Date property of that.

Something like DateTime.Parse(row.item(“columnname”)).Date