One maintenance trick which will pay off later.
Your calculation of 1209600 is (60*60*24*14). It terms of maintenance, use "(60*60*24*14)" Several times in the life-cycle of a system, you may want to just change 14 to 7 or something else. You can make the 14 a variable which is dependent upon the situation. "(60 * (60 * (24 * " + $Number of Days$ Having worked on ARS systems since 1994, this syntax has been a savior many times. Also the DateDiff function is very powerful and very fast. Functions tend to be binary code and not SQL on top of binary. This means fewer IOs which is the goal of any developer. Just a little tick of the trade. Gordon ----- Original Message ----- From: "Bruce Smith" <[email protected]> To: [email protected] Sent: Friday, October 26, 2012 1:38:09 PM Subject: BIRT Reports I am very new to BIRT and need to build a Date Range parameter that calculates all records that are still open and 14 days old from the date entered (Submit Date). I built a parameter to accept the date range and used the following: "Date entered" >= "Date entered" - 1209600 Am I suppose to use the Birt function "DateDiff(Param, Param2)integer" Any ideas? Bruce _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: "Where the Answers Are" _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: "Where the Answers Are"
