Viewing 5 posts - 1 through 6 (of 6 total)
This worked perfect
print dateadd( ss, 60, DATEADD(hh, -6, DATEADD(mm, DATEDIFF(mm,0,GETDATE()), 0)))
I was so close of course forgot the last ) at the end!
Thank you
February 10, 2012 at 12:17 pm
When I remove the consumption column it works fine so I believe there is a problem with the =Fields!Column_6.Value-Previous(Fields!Column_6.Value) statement.
August 16, 2011 at 10:03 am
Yes I am trying to round off the entire values column. I did look at the link you posted prior to my post. Which is where I am confused. It...
October 18, 2010 at 11:09 am
Finally got it! Right after I hit post Reply lol!
WHERE TSTAMP >= DATEADD(ss, +15, DATEADD(mm, DATEDIFF(mm,0,GETDATE()) -1, 0))
AND TSTAMP < DATEADD(ss, +15, DATEADD(mm, DATEDIFF(mm,0,GETDATE()), 0))
October 13, 2010 at 11:21 am
Viewing 5 posts - 1 through 6 (of 6 total)