RE: SQL Help

["John Candidi" <jacandidi@xxxxxxxxxxxxxxxxxxxx>]

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