Don,
 
You asked:
 
>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?
>
<snip>
 
Try using the following:
 
DEFINE cdate DATE CENTURY INCLUDED PICTURE "^^^^^^^^" = NCONVERT(imagex[1:8])
 
Where 'cdate' is the field you wish to use with the date functions; and
where 'imagex' is the IMAGE field you currently have defined as YYYYMMDDHHMM.
 
This will strip off the HHMM and convert the remaining digits into a DATE type
field.
 
Regards,
Gordon
 
 
==========================HP3000=Channel=Partner===========================
G.R. Helm, Inc.                                   Voice: 916.933.9669
4993 Golden Foothill Parkway                        Fax: 916.933.9696
Suite 9                                           Email: [log in to unmask]
El Dorado Hills, CA  95762                         http://www.grhelm.com
 ==========================================================================