I am attempting to convert a Report Writer report to Web Based report that captures WAN circuit utilization over the past 30 days. I built in Web Based using the SQL preview from Report Writer and the report functions ok with the exception of the last 30 days.
SQL shows the last 30 days something like this:
WHERE
( DateTime BETWEEN 44106 AND 44137 )
I understand that the 5 digit date code is a conversion from dates to numbers so it is actually capturing a specific 30 day time period. So copying this into a Web Based report with those specified date conversions means this report will only report on that specified 30 day time period.
With Report Writer there is the TimeFrame tab where the Last 30 days is chosen for Named Time Frame and the report works as expected in Report Writer. I need this report to have the same rolling 30 days for the Web Based report.
I have been unable to find the correct SQL syntax to make this work.
Thanks.
