Focal Point Banner


As of December 1, 2020, Focal Point is retired and repurposed as a reference repository. We value the wealth of knowledge that's been shared here over the years. You'll continue to have access to this treasure trove of knowledge, for search purposes only.

Join the TIBCO Community
TIBCO Community is a collaborative space for users to share knowledge and support one another in making the best use of TIBCO products and services. There are several TIBCO WebFOCUS resources in the community.

  • From the Home page, select Predict: WebFOCUS to view articles, questions, and trending articles.
  • Select Products from the top navigation bar, scroll, and then select the TIBCO WebFOCUS product page to view product overview, articles, and discussions.
  • Request access to the private WebFOCUS User Group (login required) to network with fellow members.

Former myibi community members should have received an email on 8/3/22 to activate their user accounts to join the community. Check your Spam folder for the email. Please get in touch with us at community@tibco.com for further assistance. Reference the community FAQ to learn more about the community.


Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     [CLOSED] Set Default Calendar date

Read-Only Read-Only Topic
Go
Search
Notify
Tools
[CLOSED] Set Default Calendar date
 Login/Join
 
Platinum Member
posted
Is it possible to set previous day as the default for that calendar function on the HTML form. CODE below

 ENGINE SQLMSS SET DEFAULT_CONNECTION IVB
SQL SQLMSS
EX dbo.mPulse18 '&dte'
;
TABLE FILE SQLOUT
PRINT *
ON TABLE HOLD AS SQLOUT
END

SET NODATA = ' '

-Web;
DEFINE FILE SQLOUT
-*QDATE/MDYY=QTDATE;
NEWDATE/MDYY=HDATE(QTDATE, 'MDYY');
END


TABLE FILE SQLOUT
PRINT 
 
     EmpID AS 'Employee ID'
     FName AS 'First Name'
     LName AS 'Last Name'
     Division
     Team
     TeamID AS 'Team ID'
     Role
     TotPts AS 'MTD Points'
     TotRnk AS 'MTD Rank'
     COMPUTE Rnk/D6.1% = PctRnk * 100;
 AS 'MTD   %Rank                           '
     TmPts AS 'MTD Team Points'
     COMPUTE TmRnk/D6.1% = TmPctRnk * 100; AS 'Team %Rank'
     RCpH AS 'RevCred per Hour'
     RCpHRnk AS 'RCpH Rank'
     COMPUTE AHTRnk/D6.1% = RCpHPctRnk * 100; AS 'RCpH %Rank'
     RCpHPts AS 'RCpH Points'
     UpH AS 'Units per Hour'
     UpHRnk AS 'UpH Rank'
     COMPUTE UpHRnk/D6.1% = UpHPctRnk * 100; AS 'UpH %Rank'
     UpHPts AS 'UpH Points'
     Prod AS 'Productive Time'
     ProdRnk AS 'Prod Rank'
     COMPUTE PRODRnk/D6.1% = ProdPctRnk * 100; AS 'Prod %Rank'
     ProdPts AS 'Prod Points'
     CIQ
     CIQRnk AS 'CIQ Rank'
     COMPUTE CIQRnk/D6.1% = CIQPctRnk * 100; AS 'CIQ %Rank'
     CIQPts AS 'CIQ Points'
     Qual AS 'Quality Monitoring'
     QualRnk AS 'Quality Rank'
     COMPUTE QualRnk/D6.1% = QualPctRnk * 100; AS 'Quality %Rank'
     QualPts AS 'Quality Points'
     M1TotPts AS 'Month1 Points'
     COMPUTE M1Rnk/D6.1% = M1PctRnk * 100; AS 'Month1 %Rank'
     M1TmPts AS 'Month1 Team Points'
     COMPUTE M1TmRnk/D6.1% = M1TmPctRnk * 100; AS 'Month1 Team %Rank'
     M2TotPts AS 'Month2 Points'
     COMPUTE M2Rnk/D6.1% = M2PctRnk * 100; AS 'Month2 %Rank'
     M2TmPts AS 'Month2 Team Points'
     COMPUTE M2TmRnk/D6.1% = M2TmPctRnk * 100; AS 'Month2 Team %Rank'
     M3TotPts AS 'Month3 Points'
     COMPUTE M3Rnk/D6.1% = M3PctRnk * 100; AS 'Month3 %Rank'
     M3TmPts AS 'Month3 Team Points'
     COMPUTE M3TmRnk/D6.1% = M3TmPctRnk * 100; AS 'Month3 Team %Rank'
     QAvgPts AS 'Quarterly Points'
     COMPUTE QRnk/D6.1% = QPctRnk * 100; AS 'Quarterly % Rank'
     QTmPts AS 'Quarterly Team Points'
     COMPUTE QTmRnk/D6.1% = QTmPctRnk * 100; AS 'Quarterly Team %Rank'
HEADING
"Sales IB Core"
"Date:<NEWDATE"
" "
FOOTING
""
ON TABLE SET PAGE-NUM OFF
ON TABLE NOTOTAL
ON TABLE PCHOLD FORMAT &WFFMT
ON TABLE SET HTMLCSS ON
ON TABLE SET STYLE * 

This message has been edited. Last edited by: Kerry,


WebFocus 7.7.02 WinXP
 
Posts: 236 | Registered: May 12, 2006Report This Post
Virtuoso
posted Hide Post
Are you wanting a default date for the amper variable or are you wanting a default date to display in a calendar control? If it's just the variable, just take &YYMD and subtract a day (using the DATECVT function.) If it's for display in a control, there are many examples on the web of Javascript code to handle this.

You mention an HTML form, but there is nothing here to indicate that one has been prepared, so I'm assuming that you're relying on autoprompting. Is that correct? If so, I'll just say that (in my opinion) autoprompting should ONLY be used for the simplest procedures (basically fill in some text or combo boxes.)

If you're wanting to control the display values or have any additional processing that should happen or manipulation of variables, you probably should create your own HTML form where you have complete control over everything, instead of trying to find ways to make autoprompting do what you want and then hoping it works consistently. I know autoprompting can handle a lot of those things, but it's sometimes amazing the lengths that are taken to make it work properly when an HTML page can be laid out just as quickly and allows for much greater control.

(Sorry for the soapbox speech - (especially if you weren't even trying to use autopromting. My misunderstanding, in that case.)


Regards,

Darin



In FOCUS since 1991
WF Server: 7.7.04 on Linux and Z/OS, ReportCaster, Self-Service, MRE, Java, Flex
Data: DB2/UDB, Adabas, SQL Server Output: HTML,PDF,EXL2K/07, PS, AHTML, Flex
WF Client: 77 on Linux w/Tomcat
 
Posts: 2298 | Location: Salt Lake City, Utah | Registered: February 02, 2007Report This Post
  Powered by Social Strata  

Read-Only Read-Only Topic

Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     [CLOSED] Set Default Calendar date

Copyright © 1996-2020 Information Builders