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 |
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.R | Title | User | Personal Name | Date | Lines |
---|---|---|---|---|---|
338.1 | EDIT command | PLOP::COYLE | Tue May 08 1990 14:11 | 9 | |
You can use: - SET &MONTH=EDIT(&YMD,'$$99$$'); KC | |||||
338.2 | It Works - Thanks | SCOLOX::DANDREA | Wed May 09 1990 16:40 | 12 | |
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 |