handle dates with 00:00:00 style offsets