[CLOSED] Using DOW or the actual months name

Focal Point

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

September 03, 2009, 02:18 PM

Denny99

[CLOSED] Using DOW or the actual months name

Hi all,
First, I'm using Webfocus 7.1.4 Developer Studio.

I'm creating a report which requires that the Month and Day is spelled out (or abbriviated). I have no issue getting the numeric representation using HPART but how do I put the Month or Day into alphanumeric words without writing an "IF" statement.

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

September 03, 2009, 02:26 PM

GinnyJakes

Is this what you want?

DEFINE FILE CAR
NEWDATE/MtrDYY=&MDYY;
END
TABLE FILE CAR
PRINT COUNTRY NEWDATE
END

Look up date format options in the documentation. You can search in Developer Studio help, type in 'date format' for the search string and look for the same words about 7-8 lines down. You will see all of the date format display options.

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

September 03, 2009, 03:28 PM

Francis Mariani

DEFINE FILE CAR
NEWDATE/wrMtrDYY=&MDYY;
END
TABLE FILE CAR
PRINT COUNTRY NEWDATE
END

to also get the day name.

Francis

Give me code, or give me retirement. In FOCUS since 1991

Production: WF 7.7.05M, Dev Studio, BID, MRE, WebSphere, DB2 / Test: WF 8.1.05M, App Studio, BI Portal, Report Caster, jQuery, HighCharts, Apache Tomcat, MS SQL Server