Welsh Corgi (4/16/2014)
I was thinking get the first day of the previous and current month to exclude the Timestamp and use a less then first day of current month?I do not wasn't to miss anything.
That is absolutely the best and most bullet-proof way to do it even if a column supposedly won't ever have times in it or because it's a DATE column. It will survive changes to the underlying datatypes for the columns, new datatypes, etc, etc, without any code changes.
--Jeff Moden
Change is inevitable... Change for the better is not.