Don,
 
Powerhouse DEFINE does have a format of YYYYMMDD but not YYYYMMDDHHMM.
You will have to extract the two parts of this TurboImage item, as follows:
 
ACCESS file
 
DEFINE D-YYYYMMDD DATE FORMAT YYYYMMDD = &
    DATE (DAYS ( (NCONVERT (DATETIME-ITEM [1:8]) ) ) )
 
DEFINE D-HHMM NUMERIC = NCONVERT (DATETIME-ITEM [8:4] )
 
REPORT &
    D-YYYYMMDD &
    D-HHMM PIC "^^:^^"
 
Call me if you need further help.
 
Are you aware that there is a PowerHouse List? Just send a message "subscribe
powerh-l Don Harrington" to [log in to unmask], without the quotes, of course.
 
Leonard Berkowitz
RIA Group (Warren, Gorham & Lamont
617-292-8349
 
 
______________________________ Reply Separator _________________________________
Subject: Using X-type Dates in QUIZ Date Functions
Author:  Don Harrington <[log in to unmask]> at Internet-Exchange
Date:    07/25/96 10:51 AM
 
 
I have a number of dates (YYYYMMDDHHMM) in IMAGE X fields.  What
translations do I need to go through to be able to use ethe QUIZ date
functions on these fields?  I've tried using substrings.  Do I need to
create separate items that are equated to the substrings I want to use?
 
TIA!
 
 
Don  Harrington                         Boeing Commercial Airplane Group
(206) 931-4457 voice                    P. O. Box 3707 M/S 5J-34
(206) 931-9085 FAX                      Seattle, WA  98124-2207
[log in to unmask]
 
These thoughts are owned by the person expressing them, and no one else!