× The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.



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 thread ...

Replies:

Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

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.