Dateformat in datagridview

Question

Anilkumark3888

Member since 2018

13 posts

Staidlogic

Posted: Jan 17, 2019

Last activity: Jan 18, 2019

Posted: 17 Jan 2019 5:00 EST
Last activity: 18 Jan 2019 6:20 EST

Closed

Dateformat in datagridview

Report

while exporting data from excel into datagridview .i am unable to fetch the exact date. i am attaching the same screenshot for reference.

help me resloving these problem.

Thanks&regards

Anilkumarreddy

To see attachments, please log in.

Robotic Process Automation

Like (0)
Share this page Facebook Twitter LinkedIn Email Copying... Copied!

Posted: 5 years ago

Posted: 17 Jan 2019 22:50 EST

grona replied to Anilkumark3888

Report

Are you pulling the cell value out as a string?

To see attachments, please log in.

Like (0)

Posted: 5 years ago

Posted: 18 Jan 2019 0:24 EST

Anilkumark3888

Staidlogic

replied to Anilkumark3888

Report

We are directly exporting it to Datagridview. But we are not taking it seperately as a string. How can we change its state from string to Date format?

To see attachments, please log in.

Like (0)

Posted: 5 years ago

Posted: 18 Jan 2019 6:20 EST

Jayachandra Reddy K

Infosys

replied to Anilkumark3888

Report

Try by applying dateformat on columns using c# code.

dataGridView1.Columns[0].DefaultCellStyle.Format = "dd/MM/yyyy";

To see attachments, please log in.

Like (0)

Question

Dateformat in datagridview

Need help or want to help others?

Experience the benefits of Support Center when you log in.

Question

Dateformat in datagridview

Related content:

Need help or want to help others?

Experience the benefits of Support Center when you log in.

We'd prefer it if you saw us at our best.