A while back I wrote about how to use Javascript to calculate date functions in BIRT. In this post I will show different methods that can be used to automatically calculate dates so it can be scheduled as a rolling date report. The example I will use is for a …

One of the common tasks a report writer can be asked to do is sort or limit information based on certain dates or date ranges. They could use SQL functions like:

matusetrans.actualdate >= dateadd(day, -7, convert(varchar, getdate(), 101))

workorder.reportdate >= getdate() - 7
 

po.followupdate - getdate() >= 0

matusetrans.actualdate …