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.
Focal Point    Focal Point Forums    Search    Search Results
Page 1 2 3 4 5 6
 Go Search Tools
 Search Results: (117 matches) New Search
 RE: [SOLVED]how to calculate the week of the monthby TrudySorry folks realized I posted extra field calculations that I need for my report that aren't necessa...... April 20, 2020 12:49 PM  RE: [SOLVED]how to calculate the week of the monthby TrudyThanks to everyone. I used the following code to get the two weeks like Tony suggested and then subt...... April 20, 2020 12:36 PM  RE: [SOLVED]how to calculate the week of the monthby TrudyTony, Not sure I understand how your post works. If the 1st day of the month falls on a Friday then...... April 17, 2020 11:39 AM  [SOLVED]how to calculate the week of the monthby TrudyDoes anyone know how to calculate the week of the month? I can get the week of the year but need to ...... April 17, 2020 09:22 AM  RE: [SOLVED]2ND Level Across Varianceby TrudyThanks everyone I used David's solution. I did try Frans solution but had an issue with the format o...... September 30, 2019 08:12 AM  [SOLVED]2ND Level Across Varianceby TrudyI would like to have a variance appear on a second level ACROSS hierarchy. ...... September 26, 2019 09:22 AM  [SOLVED]Format a number from a hold fileby TrudyI have a PRINT field that I convert from a D20.2 to an I3 that gets put in a hold file, XFOCUS or FO...... August 22, 2019 01:01 PM  RE: [SOLVED] Conditional Joinby TrudyThat did it, it cleared up the multiples and the where clause worked. Thanks... March 13, 2019 08:16 AM  RE: [SOLVED] Conditional Joinby TrudyI was following an example I from IBI's Tech Support page and that was what they had. When I commen...... March 12, 2019 04:19 PM  [SOLVED] Conditional Joinby TrudyI am trying a conditional join that works but when I try to report out a field from the cross refere...... March 12, 2019 03:50 PM  RE: [SOLVED]concatenating an apostrophe to a stringby TrudyThe COMPUTE worked but the SET did not. Thanks!... February 22, 2019 02:36 PM  RE: [SOLVED]concatenating an apostrophe to a stringby TrudyThat doesn't actually display the ' before the number. I still am displaying only 19 not '19. I've t...... February 22, 2019 01:47 PM  [SOLVED]concatenating an apostrophe to a stringby TrudyI can't get the synatax right for adding an apostrophe in front of a string. I've tried the two scen...... February 22, 2019 01:01 PM  RE: [SOLVED]-IF statement not working correctlyby TrudyGamP Your solution was correct, thank you. I don't know how you figured it out from the echo though...... February 01, 2019 01:40 PM  RE: [SOLVED]-IF statement not working correctlyby TrudyI tried that and it didn't work, got the same results.... January 30, 2019 03:33 PM  [SOLVED]-IF statement not working correctlyby TrudyCan anyone see what is wrong with this code, it should be going to the PSYCEND and I can't seem to g...... January 30, 2019 03:25 PM  RE: [Solved]Error Message windowby TrudyBoth methods worked, thanks!... October 25, 2018 04:08 PM  [Solved]Error Message windowby TrudyI would like to have an error message window with specific text in it to open up to the user after a...... October 25, 2018 01:18 PM  [SOLVED]null value in a P9.3 fieldby TrudyI am creating a Define field as a P9.3 and by default the value of an empty field displays as .000. ...... October 23, 2018 02:44 PM  [SOLVED]Age calculationby TrudyI need to calculate the age in years between two date fields. The date of birth and the beginning of...... September 28, 2018 11:08 AM