One advantage to the varchar solution is that (if it was converted to use ISO data formats), the end dates could have 'T23:59:59.997' added to them so the date ranges...