Not a legal OleAut date

[Shobhit_sachan]

hello all,

what is this error?and how to solve it??

[Rammohan91 (Rammohan Banda)]

Do you have any data as the date in your excel?

Thanks,
Rammohan B.

[Shobhit_sachan]

yes

[aksh1yadav (AKSHAY YADAV)]

Hey @Shobhit_sachan

Are you connecting Excel via Connection string and ole adapter?

Do one thing just use

DateTime Date = DateTime.FromOADate(Your Value replace here)

Regards…!!
Aksh