Great information. Thanks much to both of you for answering. Now to move forward with implementing and see how it goes.

Cheers

Thanks to all who have looked at this and thought about it. I found the answer buried on a post somewhere. Through all the confusing ones out there where the...

And now to find out that DatAdd in SSRS is different then the DateAdd command when writing a query is SQL. This does not make sense on how to do...

I found that this code will translate this corretly is DATEADD(s,cdr.[dateTimeOrigination],'19700101'). Now trying to addthis to the report but not sure if this goes into the Dataset Properties or into...