Comments by psima (Top 4 by date)

For the first time is it asking for your credentials? & next time is it taking the credentials which is saved by browser for the first time?

can you please share your design page as well i.e. aspx?
We need more details of what is extraFieldName, extraFieldValue,dt,count etc.

CREATE TABLE testDateTime
(
id int not null,
OrderDate DateTime
)

insert into testDateTime values(1,'12/31/2013');
insert into testDateTime values(2,Cast('31-Dec-2014' AS DateTime));

Select * from testDateTime