Is it possible to convert date to OA date format?

[samir (Samir Mohite)]

is it possible to convert date to OA date format ?

because I want to compare my date to all the dates in excel, so when I read Range date column, it gives me all the OA dates, so if conversion of date to OA date is possible then it would be easy for me to simply convert my date into OA date and compare them.

[Naveen_tg (Naveen)]

Hi @samir,
refer this link

DateTime.ToOADate Method (System)

[srishsai (Srish Aurangabadkar)]

Hi Samir,

Try this system.DateTime.FromOADate

I hope this helps

Regards
Srish

[samir (Samir Mohite)]

hey @srishsai

Thanks buddy,
but what if I want to convert my date into OA date format,
because it would be easy for me to convert only my date and compare it to all the date I have from the excel (in OA date format)

[srishsai (Srish Aurangabadkar)]

Dear @samir,

try this one
system.DateTime.Now.ToOADate

I hope this solves

[Roboz (Arun Kumar)]

Try this one:
system.DateTime.Today.ToOADate.ToString

[samir (Samir Mohite)]

hey, yeah it works… but instead of now i used Today to get OA date for date(05/02/2019).

Thanks,
Regards
Samir.

[samir (Samir Mohite)]

yes!! got it. Thanks for the reply.