Focal Point
Help Need For Print Smart Date

This topic can be found at:
https://forums.informationbuilders.com/eve/forums/a/tpc/f/7971057331/m/6781045081

August 16, 2006, 07:36 AM
ktnj
Help 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
KevinG
KT,

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


WF 7.6.10 / WIN-AIX
August 25, 2006, 07:23 AM
ktnj
This 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!