|
You have to tell the CVTDAT command what format the date is in, that you are giving it. 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 12:43 PM Please respond to Midrange Systems Technical Discussion <midrange-l@xxxxxxxxxxxx> To Midrange Systems Technical Discussion <midrange-l@xxxxxxxxxxxx> cc 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.
As an Amazon Associate we earn from qualifying purchases.
This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].
Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.