Getting date with time

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.

cheers :slight_smile:

which column you want??
from above screenshot?

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

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

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.