Hi, I have many pages on my web pages where user are to enter the time period they have worked .i.e two weeks being say 01/07/2012 to the 14/07/2012. That is from the ist second of 01/07/2012 to the last second of the 14/07/2012 (14 days) . This is what all users enter in intuitively when meaning the period is 14 days. However , the default time that is being entered of the datetime types is 12am which means the 1st second in 01/07/2012 to the first second of the 14/07/2012 which is only 13 days. I am looking for an easy way around this by changing the default time of a datetime type column to 11.59 pm(end of day) instead of 12.00 am (start of day). Anyone know a solution to this problem. On my site I am using a combination of typed datasets and linq to entities models. Any Help much appreaciated.
...
Go to the complete details ...