Focal Point
[SOLVED] Converting a date time field to a smart date

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

January 22, 2009, 11:18 AM
IMblessed
[SOLVED] Converting a date time field to a smart date
I have a date time field in the master fime . I using the Hdate to change the filed to a smart date.
Fileda/yymd=Hdate(fieldb,yymd);
I receive this syntax
FOC258) FIELDNAME OR COMPUTATIONAL ELEMENT NOT RECOGNIZED: YYMD
What wrong with this?

This message has been edited. Last edited by: Kerry,


EDA764 Release * Current Software:
Unix
January 22, 2009, 11:28 AM
GinnyJakes
The YYMD needs to be in single quotes according to the documentation. I would also suggest that you code the name of the subroutine in upper case.


Ginny
---------------------------------
Prod: WF 7.7.01 Dev: WF 7.6.9-11
Admin, MRE,self-service; adapters: Teradata, DB2, Oracle, SQL Server, Essbase, ESRI, FlexEnable, Google
January 22, 2009, 12:03 PM
IMblessed
Ginny,
In the webfocus 7 keysheet quick reference guide it has no quote in the syntax for format.
Thanks


EDA764 Release * Current Software:
Unix
January 22, 2009, 12:09 PM
GinnyJakes
It does in the manual.


Ginny
---------------------------------
Prod: WF 7.7.01 Dev: WF 7.6.9-11
Admin, MRE,self-service; adapters: Teradata, DB2, Oracle, SQL Server, Essbase, ESRI, FlexEnable, Google
January 22, 2009, 12:41 PM
j.gross
quote:
In the webfocus 7 keysheet quick reference guide it has no quote in the syntax for format.


Look again. Two forms are given for format -- either a smartdate format in single-quotes, or a fieldname without quotes. What could be clearer?
January 22, 2009, 01:55 PM
IMblessed
J.gross,
I see it now.
Thanks


EDA764 Release * Current Software:
Unix