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     Problem with & variable

Read-Only Read-Only Topic
Go
Search
Notify
Tools
Problem with & variable
 Login/Join
 
<Ed>
posted
hi all,

I am executing a report using webfocus. the fex, checks to see if the month is FEB and the year is a leap year...to set the number of days in the drill down to 28/29 resp.

it then makes a variable called:
&DRILL_ENDDATE which has the YYYYMMDD format.
for this date.

I checked this variable....and it has the value of 20050228.

later on, while it builds the report in a excel file, the report has a column for serial number...which has links calling another fex.

URL=http://&&WEBURL/cgi-bin/ibi_cgi/webapi.dll?(IBIF_ex='SH' s_lst=N2 t_rng=&DRILL_ENDDATE f_rng=&DRILL_STARTDATE),

there is no mention of the &DRILL_ENDDATE between this line and the line in which it is set.
however, on running the report... the excel file link shows t_rng=20050229

Any idea, how the date changed from 28 to 29.?

thanks

-Ed.
 
Report This Post
<Zushi Hitoshi>
posted
For instance, how because it is as follows?

-SET &WYY3D=EDIT(&YYMD,'99990301');
-SET &WYYMD=AYMD(&WYY3D,-1,'I8');
-TYPE &WYYMD
 
Report This Post
Leo L
Gold member
posted Hide Post
I think the best bet would be to verify your code and make sure its 20050228 right before you use it... Based on what you said... perhaps make sure when your checking to see if its 28 or 29 that its not incorrectly giving 29. Its tough without seeing the code, but it could either be the logic used to assign it to 29 or your using the same variable name somewhere else without realizing it. If your sure it gives the correct answer, change the name of the variable to ensure its not being used anywhere else.

Leo
 
Posts: 96 | Location: Winnipeg, Manitoba, Canada | Registered: January 22, 2004Report This Post
reFOCUSing
Guru
posted Hide Post
If you want and easy way to get the end of a month try using the following code:

-SET &DT = 20040201;
-SET &END_YYMD = DATECVT((DATEMOV((DATECVT(&DT,'I8YYMD','YYMD')),'EOM')),'YYMD','I8YYMD');
-TYPE &END_YYMD
The function DATEMOV is what does the trick.

This message has been edited. Last edited by: <Mabel>,
 
Posts: 406 | Location: Canada | Registered: May 31, 2004Report 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     Problem with &amp; variable

Copyright © 1996-2020 Information Builders