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    Search    Search Results
Page 1 ... 24 25 26 27 28 29 30 ... 61
Go
Search
Tools
Search Results: (1213 matches) New Search Login/Join 

Discussion Topic  RE: [SOLVED]difference between 2 dates in WEEKS! (in WebFOCUS/FOCUS Forum on Focal Point ) by Dan Satchell
I believe 5,727 is the number of weeks between 1/1/1901 and 5/6/2011. So it appears your code is us......
Focal Point > Focal Point Forums > WebFOCUS/FOCUS Forum on Focal Point

Discussion Topic  RE: [SOLVED]difference between 2 dates in WEEKS! (in WebFOCUS/FOCUS Forum on Focal Point ) by Dan Satchell
......
Focal Point > Focal Point Forums > WebFOCUS/FOCUS Forum on Focal Point

Discussion Topic  RE: [SOLVED]difference between 2 dates in WEEKS! (in WebFOCUS/FOCUS Forum on Focal Point ) by Dan Satchell
Remove it and find out. In multi-segment files (like the CAR file) DEFINEs must reference a real fi......
Focal Point > Focal Point Forums > WebFOCUS/FOCUS Forum on Focal Point

Discussion Topic  RE: [SOLVED]difference between 2 dates in WEEKS! (in WebFOCUS/FOCUS Forum on Focal Point ) by Dan Satchell
If you want a DEFINE/COMPUTE, try something like this: ......
Focal Point > Focal Point Forums > WebFOCUS/FOCUS Forum on Focal Point

Discussion Topic  RE: [SOLVED]difference between 2 dates in WEEKS! (in WebFOCUS/FOCUS Forum on Focal Point ) by Dan Satchell
Or you could use legacy date function DAMDY. However, this approach assumes the input dates are alw......
Focal Point > Focal Point Forums > WebFOCUS/FOCUS Forum on Focal Point

Discussion Topic  RE: [SOLVED] Special Character in Count (in WebFOCUS/FOCUS Forum on Focal Point ) by Dan Satchell
If the currency symbol trick described above won't work in your case, then another approach is to us......
Focal Point > Focal Point Forums > WebFOCUS/FOCUS Forum on Focal Point

Discussion Topic  RE: [SOLVED] Special Character in Count (in WebFOCUS/FOCUS Forum on Focal Point ) by Dan Satchell
If your report does not contain any other amounts with currency symbols (such as '$'), you can use a......
Focal Point > Focal Point Forums > WebFOCUS/FOCUS Forum on Focal Point

Discussion Topic  RE: [SOLVED] HOW TO COMBINE TWO OR MORE FIELDS (in WebFOCUS/FOCUS Forum on Focal Point ) by Dan Satchell
Seems like you may be looking for counts instead of sums? Maybe something like this: ......
Focal Point > Focal Point Forums > WebFOCUS/FOCUS Forum on Focal Point

Discussion Topic  RE: [SOLVED] test if the report is executed via reportcaster or in an other way (in WebFOCUS/FOCUS Forum on Focal Point ) by Dan Satchell
Check the values of variables &FOCFOCEXEC and &DSTJOBNAME when running a procedure interactively and......
Focal Point > Focal Point Forums > WebFOCUS/FOCUS Forum on Focal Point

Discussion Topic  RE: [SOLVED] last day of previous month (in WebFOCUS/FOCUS Forum on Focal Point ) by Dan Satchell
Another approach is to use legacy date function AYMD: ......
Focal Point > Focal Point Forums > WebFOCUS/FOCUS Forum on Focal Point

Discussion Topic  RE: [CLOSED] Pass numeric formatting to hold file output (in WebFOCUS/FOCUS Forum on Focal Point ) by Dan Satchell
You could use function PTOA (or FTOA) to convert your numbers into alphanumeric values, including fo......
Focal Point > Focal Point Forums > WebFOCUS/FOCUS Forum on Focal Point

Discussion Topic  RE: [SOLVED] Convert a DateTime to Alpha for Compare (in WebFOCUS/FOCUS Forum on Focal Point ) by Dan Satchell
If the EDIT on the input times didn't work, you might be able to combine the input data without any ......
Focal Point > Focal Point Forums > WebFOCUS/FOCUS Forum on Focal Point

Discussion Topic  RE: [SOLVED] Convert a DateTime to Alpha for Compare (in WebFOCUS/FOCUS Forum on Focal Point ) by Dan Satchell
The direct assignment to a legacy date (A8YYMD) doesn't work because of the slashes in the input dat......
Focal Point > Focal Point Forums > WebFOCUS/FOCUS Forum on Focal Point

Discussion Topic  RE: [SOLVED] Convert a DateTime to Alpha for Compare (in WebFOCUS/FOCUS Forum on Focal Point ) by Dan Satchell
Try putting single quotes around the input date: ......
Focal Point > Focal Point Forums > WebFOCUS/FOCUS Forum on Focal Point

Discussion Topic  RE: [SOLVED] Convert a DateTime to Alpha for Compare (in WebFOCUS/FOCUS Forum on Focal Point ) by Dan Satchell
..... otherwise, function HCNVRT will convert date-time values to alphanumeric....
Focal Point > Focal Point Forums > WebFOCUS/FOCUS Forum on Focal Point

Discussion Topic  RE: [SOLVED] Convert a DateTime to Alpha for Compare (in WebFOCUS/FOCUS Forum on Focal Point ) by Dan Satchell
Why not convert your input dates/times to date-time fields? Something like this should work: ......
Focal Point > Focal Point Forums > WebFOCUS/FOCUS Forum on Focal Point

Discussion Topic  RE: [CLOSED not SOLVED] Mainframe FOCUS - How to determine which row causes format error? (in WebFOCUS/FOCUS Forum on Focal Point ) by Dan Satchell
If not already the case, and if possible, I would convert all numeric data elements to alpha format....
Focal Point > Focal Point Forums > WebFOCUS/FOCUS Forum on Focal Point

Discussion Topic  RE: [CLOSED] Finding the number of business days (M-F) between two dates. (in WebFOCUS/FOCUS Forum on Focal Point ) by Dan Satchell
On closer examination, HDIFF may not do business days. Instead, convert your date-time values to Sm......
Focal Point > Focal Point Forums > WebFOCUS/FOCUS Forum on Focal Point

Discussion Topic  RE: [SOLVED]conditional styling in the subfoot - tabfooting (in WebFOCUS/FOCUS Forum on Focal Point ) by Dan Satchell
You will need to clearly identify the SUBFOOT line number and item number of the object you wish to ......
Focal Point > Focal Point Forums > WebFOCUS/FOCUS Forum on Focal Point

Discussion Topic  RE: [SOLVED]conditional styling in the subfoot - tabfooting (in WebFOCUS/FOCUS Forum on Focal Point ) by Dan Satchell
From what I can make of this, I think Charles wants to force the first text object in his SUBFOOT in......
Focal Point > Focal Point Forums > WebFOCUS/FOCUS Forum on Focal Point


» Refine Search
» New Search

  Powered by Social Strata Page 1 ... 24 25 26 27 28 29 30 ... 61 

Focal Point    Focal Point Forums    Search    Search Results

Copyright © 1996-2020 Information Builders