Convert Number String to Date

veerendrakumar · May 1, 2019, 4:57pm

Hi,

I am trying to convert 5012019 to a Date 05/01/2019. i read the date from excel sheet as a string which is 5012019 but needs to convert as a date.

Please let me know how we can achieve this. tried all possibilities but could not get it

Thank you
Veerendra

lakshman · May 1, 2019, 5:03pm

Convert.ToDateTime(yourStringDate)

anil5 · May 1, 2019, 6:31pm

Hi @veerendrakumar,

Datetime.parseexact(“5012019”,“Mddyyyy”,system.globalization.cultureinfo.invariantculture).tostring(“MM/dd/yyyy”)

veerendrakumar · May 1, 2019, 7:05pm

Got this below Error

veerendrakumar · May 1, 2019, 7:06pm

Got this below error

lakshman · May 2, 2019, 3:22am

Could you please print the Excel value and show me once. Need to see the format how it is printing.