|
Thank you both for your time and replies. I tried Chris' solution first and it worked beautifully! -----Original Message----- From: midrange-l-bounces@xxxxxxxxxxxx [mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of Chris Payne Sent: Tuesday, February 27, 2007 2:55 PM To: Midrange Systems Technical Discussion Subject: RE: SQL Help If you field is called TextDate then you can do: Integer((Decimal(TextDate,7)+19000000)/10000) Which should get you just the year in YYYY format. Chris -----Original Message----- From: midrange-l-bounces@xxxxxxxxxxxx [mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of John Candidi Sent: Tuesday, February 27, 2007 2:47 PM To: 'Midrange Systems Technical Discussion' Subject: SQL Help I have a date in the following format CYYMMDD. This is basically just a text field in the file. I need to take just the CYY fields and present it as 1999 or 2007 or whatever it works to out be. This conversion needs to be done on the fly in a view. Any help would be greatly appreciated. If anyone needs more info, I apologize for not supplying in advance. I created the view using iNav on 5.2 John A Candidi Rutgers Insurance Companies IT Director - Iseries Manager 856-779-2274
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.