Focal Point
[SOLVED] changing the date with format I08YYMD to MDYY format

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

May 04, 2009, 01:26 PM
serenekk
[SOLVED] changing the date with format I08YYMD to MDYY format
HDATE format does not work converting the date that looks like this 2009/01/01 to look like
01/01/2009. What function can I use? regular edit does not work either.
Thanks!!

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


on VMS: OpenVMS AXP V8.2 Prod and TestEnvironment
Webfocus: WebFocus 7.6.1 Prod and TestEnvironment
May 04, 2009, 02:03 PM
GinnyJakes
DATEI/I8YYMD=20090101;
DATEN/YYMD=DATEI;
DATEM/MDYY=DATEN;


This is assuming you are doing this in a report and not in an amper variable.


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
May 04, 2009, 02:24 PM
serenekk
THANKS so much, Ginny!! it works. Could not think of this simple method and keep thinking of date functions and edit. :-D
Thanks again!


on VMS: OpenVMS AXP V8.2 Prod and TestEnvironment
Webfocus: WebFocus 7.6.1 Prod and TestEnvironment
May 04, 2009, 02:33 PM
GinnyJakes
I'm a simpleton.


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