August 16, 2006, 07:36 AM
ktnjHelp Need For Print Smart Date
I would like to print a date that is in
YYMD format in its MFD.
When I use print *, I get a string of characters, not a vaild date.
Any help is appreciated.
August 16, 2006, 12:52 PM
KevinGKT,
Is the MFD describing relational data, or a FOCUS data source. Also, please include the full line from your MFD. I suspect it is an issue with ACTAUL vs USAGE and how the data was originally loaded into the datasource.
Kevin
August 25, 2006, 07:23 AM
ktnjThis was our solution:
In MFD
FIELD=RUN_DATE ,RUN_DATE ,MDYY ,A10 ,MISSING=OFF,
DEFINE RUN_DTYYMD/YYMD = DATECVT(RUN_DATE, 'MDYY', 'YYMD');
Results:
RUN_DATE RUN_DTYYMD
-------- ----------
07/26/2006 2006/07/26
Thanks!