Sylvia,

It sounds like you have never worked in a shop (1) with data architects/modelers and (2) where have strict change control requirements are enforced.

If so, your problem...

Jeff,

WOW - you nailed it !!

I'm a long time data architect and shared your 'experiences' with developers, managers and business 'types' who have no concept of the...

the easiest way to extract date ranges without having to worry about the time parts is to subtract 1 day from the bottom of the range and add 1 day...