Thanks, I understand that we can do with with t-sql, but how can we do this from SSRS?

we record the time within our date fields (e.g. 2009-03-12 17:11:16.110)

Any way that i would be able to query that? :unsure:

I have just implimented the following into a month-end report used by the business. I have a subscription setup to run @ 7am on the first of every month.

The date...