Change the format of the variable into DateTime

[niteckam (PinkPanter)]

Hello,

What is my case.
I read from Excel File a cell. The value is 08-Jun-19

I have to choose Double type of output variable otherwise I have an

• if I choose String - 'errorRead Cell Ship Date: StringConverter cannot convert from System.Double.
• if I choose DateTime - ‘errorRead Cell Ship Date: DateTimeConverter cannot convert from System.Double.’
  So when I choose Double as a type them this is my value 43624

I have to somehow convert this variable to at the end receive the value 06/08/2019
Any help?

[Srini84 (Srinivas)]

Hi @niteckam

Check the screen below

Hope this helps

Thanks

[Debakanta_Mahanta]

Hi,

DateTime.FromOADate(43624).ToString(“dd/MM/yyyy”)

replace 43624 with respective variable