Converting Number format into Date Format

[Deep_Vekariya]

Hello everyone,

In my excel i am getting input in 43800 format i want to convert it into Date format

Thank you inadvance

[Parvathy (PS Parvathy)]

Hi @Deep_Vekariya

Try this:

DateTime.FromOADate(43800)

Regards

[lrtetala (Lakshman Reddy)]

Hi @Deep_Vekariya

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

Regards,

[Ajay_Mishra (Ajay Mahendra Mishra)]

Hey @Deep_Vekariya

Integer Number is called as OA Date,
Use below mentioned query to convert OA Date to Date Format.

Datetime.FromOADate(Cdbl(Variable_Name))

Regards,
Ajay Mishra

[Deep_Vekariya]

@Deep_Vekariya

Thanks everyone for the help,

My input was in string so,this solution is working for me

Thanks everyone for the help,

@Ajay_Mishra My input was in string so,this solution is working for me.