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

[Booth Martin <booth@xxxxxxxxxxxx>]

Thats what is confusing me.  There is no format, so far as i know, for a 
date field.  I tried *JOB but that is *MDY.  When I tried it the CVTDAT 
command failed saying there were too many or too few numeric characters. 
 I could try *ISO, but gosh... why?  I'd like to know what I am doing 
in case there are gotcha's that I should be aware of?  (I spend way to 
much of my time as it is not knowing why I do some of this stuff.   I 
still never figured out why I need chicken feet tacked to the wall for 
example, but Joe says I need it, so I do it.



Rubino, Jim wrote:
> Booth,
>
> You may need to tell the CVTDAT command what the from format is in order
> to get the to format correct.
>
> Jim
>  
>
> -----Original Message-----
> From: midrange-l-bounces@xxxxxxxxxxxx
> [mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of Booth Martin
> Sent: Monday, February 05, 2007 12:44
> To: Midrange Systems Technical Discussion
> Subject: Using CL, how do I get the month from a data date field?
>
> I have a date type field in the first record of a data file.
>
> I want to get the month from it, in CL.
>
> Here's what I tried and I can not make work:
>
> CVTDAT     DATE(&FCMDTE) TOVAR(&FCMDTE) TOFMT(*ISO)
> IF         COND(%SUBSTRING(&FCMDTE 4 2) = '04') THEN(DO)
>
> The CVTDAT fails because the CL believes the date field is *MDY (RTVJOBA
> of DATFMT = *MDY).
>
> I believe I am making this way to complicated.
>
>
> --
> ---------------------------------
> Booth Martin
> http://www.Martinvt.com
> ---------------------------------
> --
> This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing
> list To post a message email: MIDRANGE-L@xxxxxxxxxxxx To subscribe,
> unsubscribe, or change list options,
> visit: http://lists.midrange.com/mailman/listinfo/midrange-l
> or email: MIDRANGE-L-request@xxxxxxxxxxxx Before posting, please take a
> moment to review the archives at http://archive.midrange.com/midrange-l.