Excel Number To Date

[SP_Bot]

Hi Community Members

Can you please tell me to convert the Odate to desired date format

like i have a excel value as any number

Thanks

[lrtetala (Lakshman Reddy)]

Hi @SP_Bot

Datetime.FromOADate(Cdbl(Variable_Name))

Regards,

[pravallikapaluri]

Hi @SP_Bot

dateValue = DateTime.FromOADate(serialNumber)
formattedDate = dateValue.ToString("MM/dd/yyyy")

• serialNumber is the variable holding the Excel serial number.
• dateValue will be a DateTime object representing the corresponding date.

Hope it helps!!

[Nawazish_Ahmad]

Hi @SP_Bot

Try this:

Convert OAdate format into ("dd/mm/YYYY")

Hi @shiv.mandal Try This DateTime.FromOADate(44200.5).ToString("dd/MM/yyyy") [image] Hope it will helps you Cheers!!

[mkankatala (Mahesh Kankatala)]

Hi @SP_Bot

Try the below query:

Convert.ToOADate(Cdbl(row("column name").ToString))

Hope it helps!!

[lrtetala (Lakshman Reddy)]

@SP_Bot

Datetime.FromOADate(Cdbl(Input))

Datetime.FromOADate(Cdbl(Input)).ToString("MM/dd/yyyy")

Regards,