Date Range Parameter

Focal Point

This topic can be found at:
https://forums.informationbuilders.com/eve/forums/a/tpc/f/7971057331/m/7311036691

November 15, 2006, 09:45 AM

kalyanswarna

Date Range Parameter

Hi All,
i need date field as dynamic parameter with range option, i created this in where clause.

WHERE ( FILE_TRAN_D EQ DT(&FILE_TRAN_D.(FROM 2006/07/01 00:00:00 TO 2006/05/28 00:00:00).Date_Prompt.) );

but if i execute the report it is giving the error like
Unknown Error
Server is Crashed.

with out this where statement it is working fine.

Thanks,
Kalyan

Thanks,
Kalyan.S
------------------------------------
WebFOCUS 7.1.4, Win XP SP2,
Oracle8i.
------------------------------------

November 15, 2006, 09:54 AM

Francis Mariani

Have you tried single-quotes?

WHERE ( FILE_TRAN_D EQ DT(&FILE_TRAN_D.(FROM '2006/07/01 00:00:00' TO '2006/05/28 00:00:00').Date_Prompt.) );

I don't really know why and how a prompt is used in WebFOCUS.

Francis

Give me code, or give me retirement. In FOCUS since 1991

Production: WF 7.7.05M, Dev Studio, BID, MRE, WebSphere, DB2 / Test: WF 8.1.05M, App Studio, BI Portal, Report Caster, jQuery, HighCharts, Apache Tomcat, MS SQL Server

November 16, 2006, 05:48 PM

Tomsweb

CHECK THIS OUT...

<

http://techsupport.informationbuilders.com/known_problems/13312010.html>

Tomsweb
WebFOCUS 8.1.05M, 8.2.x
APP Studio, Developer Studio, InfoAssist, Dashboards, charts & reports
Apache Tomcat/8.0.36