Error in reading date value

Topics: Developer Forum, User Forum
Jul 7, 2014 at 11:07 AM
I am getting problem in reading date value.

In my excel file, I have the value as 03-07-2014 (dd-mm-yyyy) format. but when I read this, I get the value as 07-03-14 & when I store this value to database I get the value as 2007-03-14.

Please help.