Unanswered: date/time games
i need to modify a user specified "event" date.
some "events" just need the time modified to reserved times between 21:00 and 03:00 whilst other "events" need the day-of-the-month set first/last as well as the time modification.
there are eleven event "types" with different rules.
i have two functions which work perfectly but they are not very nice: they either involve cheats (dates-as-doubles) or they involve endless lines of dateadd()
any ideas for a "compound dateadd()" that handles d, h, n, s in one go but doesn't resort to dates-as-doubles tricks?
currently using SS 2008R2