[Search for users] [Overall Top Noters] [List of all Conferences] [Download this site]

Conference ilbbak::ibi_focus

Title:FOCUS, from INFORMATION BUILDERS
Moderator:ZAYIUS::BROUILLETTE
Created:Thu Feb 19 1987
Last Modified:Mon May 05 1997
Last Successful Update:Fri Jun 06 1997
Number of topics:615
Total number of notes:1779

338.0. "HELP! w/System Date" by SCOLOX::DANDREA () Tue May 08 1990 10:19

    
    	I'm trying to initiate a certain formula BASED ON THE 
    	CALENDAR MONTH (01-12) at the time of processing.
    
    	This has to be a non-interactive query, so I'd like to
    	use the &YMD system variable in my calculation.
    
    	HOW CAN I BREAK OUT THE MONTH FROM THE WHOLE DATE?????
    
    	(Example:  Use 'X' if the MONTH is '01' or '04' or '07' or '10'
    		   Use 'Y' if the MONTH is '02' or '05' or '08' or '11'
                   Else use 'Z'
    
    	I'd appreciate some suggestions - or write if you need more info.
    
    	Thanks a lot...  Nancy  (SCOLOX::DANDREA  DTN 223-2621)
    
T.RTitleUserPersonal
Name
DateLines
338.1EDIT commandPLOP::COYLETue May 08 1990 14:119

    You can use:

- SET &MONTH=EDIT(&YMD,'$$99$$');



                                     KC
338.2It Works - ThanksSCOLOX::DANDREAWed May 09 1990 16:4012
    
    KC,
    
    	Thank You Very Much!  I used your command from <.1> and 
    	was able to test with IF &MONTH EQ 05, etc., in my FEX.  
    
    	I appreciate your reply.
    
    							 -Nancy