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 firstname.lastname@example.org for further assistance. Reference the community FAQ to learn more about the community.
I need to generate the start and end dates form the system dates. The reason is to use Report Caster to generate reports at the beginning of the month. The query TABLE FILE RFIFLTREC PRINT FR_OOS_DUR FR_CLOSE_DATE FR_CLRCAT FR_DIGITAL WHERE FR_CLOSE_DATE GE '&SELFROM' AND FR_CLOSE_DATE LT '&SELTO' END
The close date is A8( i.e. 20060501) format in the master file. The requirement is to look at the system date on the 5th of the month i.e 20060605 and get the system to generate 20060501 as start date and 20060531 as the end date
Any ideasThis message has been edited. Last edited by: Kerry,
Webfocus 7.6.2 on Windows Enterprise 2003 Server and Webfocus 7.6.2 on HP Unix Server
Posts: 74 | Location: London | Registered: January 28, 2005
I think that the datemov function only works with smart dates. If you always want the first and last calendar days of the previous month based on the current system date, this will probably work for you.
This works too. DEFINE FILE CAR TODAY/MDYY = '&DATEMDYY'; BEG_CUR_MO/MDYY=DATEMOV(TODAY,'BOM'); END_CUR_MO/MDYY=DATEMOV(TODAY,'EOM'); BEG_PRIOR_MO/MDYY=DATEADD(BEG_CUR_MO,'M',-1); END_PRIOR_MO/MDYY=DATEMOV(BEG_PRIOR_MO, 'EOM'); END TABLE FILE CAR PRINT CAR NOPRINT TODAY BEG_CUR_MO END_CUR_MO BEG_PRIOR_MO END_PRIOR_MO END
In Focus since 1993. WebFOCUS 7.7.03 Win 2003
Posts: 1903 | Location: San Antonio | Registered: February 28, 2005