Assuming your DATFMT is *MDY, the date separator id *SLASH separator and
the column dayid is defined as a date, could be as easy as :
CHAR( dayid, LOCAL )
If dayid is defined as something other than a date, you'd need to convert
it from its current format into a date.
This mailing list archive is Copyright 1997-2013 by MIDRANGE dot 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 here. If you have questions about this, please contact