|
Assuming you are talking about the provided DATE keyword in DDS (which is what *DATE does for you), if your system QDATFMT date format is MMDDYY then the best you can do is change the generated DATE keyword to display it as MM/DD/YYYY with DATE(*SYS *YY) EDTWRD('0 / / /') (Assuming you want system date, and not default *JOB). Note - EDTCDE(Y) won't work for 8 digit date. If you have a true date data-type field, you can display it any way you want with the *DATFMT keyword: *ISO (default), or *JOB *MDY *DMY *YMD *JUL *USA *EUR *JIS Neil Palmer DPS Data Processing Services Canada Ltd. AS/400~~~~~ Markham, Ontario, Canada ___________ ___ ~ Phone: (905) 474-4890 x303 |OOOOOOOOOO| ________ o|__||= Cell.: (416) 565-1682 x303 |__________|_|______|_|______) Fax: (905) 474-4898 oo oo oo oo OOOo=o\ mailto:NeilP@DPSlink.com ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ http://www.DPSlink.com AS/400 The Ultimate Business Server Terry Richardson <RichardsonT@ORVIS.com> on 99-08-09 11:45:43 Please respond to MIDRANGE-L@midrange.com To: MIDRANGE-L@midrange.com cc: (bcc: Neil Palmer/Dpslink) Subject: *DATE in SDA-- hoping against hope. I'm sure this has been discussed here ad infinitum, but I just recently re-subscribed to the list, and searching the archives on MIDRANGE.COM has proven futile. In SDA, when I enter *DATE to put the job date on the screen , the date appears in MM/DD/YY format. Is there any way to have it appear in YYYY-MM-DD format without moving the *date to another field within the RPG program that drives the screens? TIA Terry Richardson Sr. P/A The Orvis Company, Inc. +--- | This is the Midrange System Mailing List! | To submit a new message, send your mail to MIDRANGE-L@midrange.com. | To subscribe to this list send email to MIDRANGE-L-SUB@midrange.com. | To unsubscribe from this list send email to MIDRANGE-L-UNSUB@midrange.com. | Questions should be directed to the list owner/operator: david@midrange.com +---
As an Amazon Associate we earn from qualifying purchases.
This mailing list archive is Copyright 1997-2025 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.