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

[shiv.mandal]

Hello community member pls help me to solve this
How to convert OAdate format into (“dd/MM/yyyy”) ? i have 44200.5 as a input

Thanks in advance

[ashokkarale]

Hi @shiv.mandal ,

Try with this expression
DateTime.FromOADate(Convert.ToDouble(inputstringvariable)).ToString(“dd/MM/yyyy”)

Regards,
Ashok

[Nawazish_Ahmad]

Hi @shiv.mandal

Try This

DateTime.FromOADate(44200.5).ToString("dd/MM/yyyy")

Hope it will helps you
Cheers!!

[supriya117 (Supriya Allada)]

Hi @shiv.mandal

Try this:

formattedDate = DateTime.FromOADate(CDbl(inputString)).ToString("dd/MM/yyyy")

[rlgandu (Rajyalakshmi Gandu)]

@shiv.mandal

YourDateVariable = DateTime.FromOADate(44200.5).ToString("dd/MM/yyyy")

[Parvathy (PS Parvathy)]

Hi @shiv.mandal

Try this:

DateTime.FromOADate(Convert.ToDouble("44200.5")).ToString("dd/MM/yyyy")

If output is of DataType System.Double then use below syntax:

DateTime.FromOADate(44200.5).ToString("dd/MM/yyyy")

Regards

[shiv.mandal]

Thank You for your help.

[shiv.mandal]

Thank you everyone for the valuable response .