Virul Patel Product : iWay Data Migrator (8.1) WebFocus 8.1 SQL SERVER 2012
June 17, 2015, 09:11 AM
Thank you for your update. Your idea is probably just as good as any. The purpose of DB_EXPR is to utilize SQL logic within WebFOCUS.
There is a DB_EXPR function that allows the use of a SQL expression that will be passed to the relational database to do the aggregation. For information, refer to chapter 3 on page 133: "DB_EXPR Function: Inserting an SQL Expression Into a Request" in the: "WebFOCUS New Features Version 7 Release 7.05" manual (DN4500997.1013) at: http://documentation.informati...ml/html_wf_7705/77sn f/7705snf.pdf (Please note the above URL spans multiple lines.)
This chapter talks about putting a SQL function in a request that is then passed over to the database engine.
There are not a lot of DATEDIFF function posts in the iWay forum but lots of different ways to use this if you search within the WebFOCUS Forum. Its really a matter of how you are using it.
I will mark the topic solved in the subject line.
WebFOCUS 8x - BI Portal, Developer Studio, App Studio, Excel, PDF, Active Formats and HTML5