posted 16 years ago
this is how my date value is inside database (sqlServer)
2007-05-04 11:39:25.553, 2007-05-03 13:37:37.150
the user can enter date in mm/dd/yyyy(dfInputdatefmt) format. so I convert it to yyyy-MM-dd hh:mm:ss:SSS(dfOutputdatefmt) like this
Then I use
if I provide dateTo as 05/04/2007 and datFrom as 01/01/2007 ..it is missing all the 05/04/2007 records.
Whats wrong? Pls help me