RE: SQL Help

["Chris Payne" <CPayne@xxxxxxxxxxxxxxx>]

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