Re: Using CL, how do I get the month from a data date field?

Hi Booth,

No, CHGVAR changes "any" variable that you specify to "any" value that you 
specify.  It does not know, nor care, if it is a date.  That is why you 
should specify the date format of the date you are trying to change, to 
the command CVTDAT.

Once CVTDAT knows what the incoming date format is, it will send you back 
the date in the format that you specify.  You can then use %SUBSTRING to 
get the values that you need.



HTH,

Nick


Nick Radich
Sr. Programmer/Analyst
EPC Molding, Inc.
Direct  (320) 679-6683
Toll free  (800) 388-2155  ext. 6683
Fax  (320) 679-4516
nick_radich@xxxxxxxxxxxxxx



Booth Martin <booth@xxxxxxxxxxxx> 
Sent by: midrange-l-bounces@xxxxxxxxxxxx
02/05/07 01:23 PM
Please respond to
Midrange Systems Technical Discussion <midrange-l@xxxxxxxxxxxx>


To
Midrange Systems Technical Discussion <midrange-l@xxxxxxxxxxxx>
cc

Subject
Re: Using CL, how do I get the month from a data date field?






Does CHGVAR always change a date field to *ISO, regardless of job & 
system attributes?

(And you are of course right about it being column 5.  *duh*  thanks.)

Lapeyre, Francis wrote:

If that's a date field, move it to an 8-character field first. Plus, in
*ISO format with no separators, the month starts in position 5.

Dcl &FCMDTE_C *Char 8
Chgvar &FCMDTE_C &FCMDT

CVTDAT DATE(&FCMDTE_C) TOVAR(&FCMDTE_C) FROMFMT(*ISO)  + 
TOFMT(*ISO) TOSEP(*NONE) 
IF         COND(%SUBSTRING(&FCMDTE 5 2) = '05') THEN(DO)


Francis Lapeyre
IS Dept. Programmer/Analyst
Stewart Enterprises, Inc.
E-mail: flapeyre@xxxxxxxx