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.
New TIBCO Community Coming Soon
In early summer, TIBCO plans to launch a new community—with a new user experience, enhanced search, and expanded capabilities for member engagement with answers and discussions! In advance of that, the current myibi community will be retired on April 30. We will continue to provide updates here on both the retirement of myibi and the new community launch.
What You Need to Know about Our New Community
We value the wealth of knowledge and engagement shared by community members and hope the new community will continue cultivating networking, knowledge sharing, and discussion.
During the transition period, from April 20th until the new community is launched this summer, myibi users should access the TIBCO WebFOCUS page to engage.
For me it works fine. The calender presents the dates in the format I specify and also the dates are in the request as entered. I specified the format to be YYMD, and as a consequence I need to enter it in YYMD format, and the values are transported back to WebFocus in my & vars as YYMD.
What exactly is it that you need? Please post the code you have already...and indicate where things go wrong in your view.
- Using AS 8.2.01 on Windows 10 - IE11.
in Focus since 1988
Posts: 1961 | Location: Netherlands | Registered: September 25, 2007
Thanks for the response. I am a newbie so I appologize if my reponses are vague in anyway....(and I am using 7703 with hotfix 2).
My problem is really with the calendar control in HTML. It seems confused, like I pick June 5, 2012 from the calendar, what ends up in the box is 12/06/05 and what appears in the sql (I have a sql tracker turned on ) is 19051206. So it is reading what is in the box as month day year , but what is in the box if formatted wrong.
What I want is to pick June 5, 2012 from the calendar, have 06/05/2012 show up in the box this would result in '20120605' in the SQL.... and work.
If I manually type 06/05/2012 in the box and do not select from the calendar, everything works fine. So it is really getting the calendar control to put that format in the box when I use the dashbaord that I have a question about.
I have attached my fex code and the code excerpt from my query:
Here is my fex code :
TABLE FILE IBI_TABLE_ID_XREF SUM CNT.IBI_TABLE_ID_XREF.IBI_TABLE_ID_XREF.VISITID WITHIN J13.IBI_TABLE_PATIENT_CLASS_DSC.PATIENTCLASSNAME AS 'COUNT,IBI_TABLE_ID_XREF.IBI_TABLE_ID_XREF.VISITID' BY J13.IBI_TABLE_PATIENT_CLASS_DSC.PATIENTCLASSNAME WHERE ( J12.IBI_TABLE_LOS_DT.DISCHARGE_DT GE '&StartDISCHARGE_DT.(<10/1/2009,10/1/2009>).Report Start Date.' ) AND ( J12.IBI_TABLE_LOS_DT.DISCHARGE_DT LE '&EndDISCHARGE_DT.(<10/1/2009,10/1/2009>).Report End Date.' ); ON TABLE SET PAGE-NUM NOLEAD ON TABLE COLUMN-TOTAL AS 'TOTAL' 'IBI_TABLE_ID_XREF.IBI_TABLE_ID_XREF.VISITID' ON TABLE PCHOLD FORMAT HTML ON TABLE SET HTMLCSS ON ON TABLE SET STYLE * INCLUDE = endeflt, $ ENDSTYLE END
Hi Tom, The "Data Format in Data Source" box seems to be doing nothing. I can change it to MDYY and (T4."Discharge_Dt" BETWEEN '19051206' AND '19051206') still ends up in SQL. For giggles I changed it to wrMtrDYY and still get (T4."Discharge_Dt" BETWEEN '19051206' AND '19051206'). The diplayed date in the calendar box also remains as 12/06/05.
Check the Properties box for your calendar control and make sure the property Name is the same as the variable name your focexec expects. Also check in the Parameters tab that your calendar control parameter (same as the property Name) is bound to the calendar control.
Posts: 1213 | Location: Seattle, Washington - USA | Registered: October 22, 2007