[SOLVED] Convert Decimal to Year

Focal Point

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

October 28, 2009, 07:41 AM

[SOLVED] Convert Decimal to Year

Hi All,
How can i convert a decimal ( '2009.90'where 90 is the month) into year format of 2009?

thanks
RP

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

webfocus 7.6.9 windows XP Excel

October 28, 2009, 10:07 AM

Francis Mariani

What month is 90 supposed to represent? If it's September, how does October get represented?

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

October 28, 2009, 10:11 AM

Francis Mariani

You specify "date" in the title of the post, but then specify "year" in the actual post".

This puts the year portion in a year field:

DEFINE FILE CAR
STRANGE_DATE/P7.2 = 2009.90;
END

TABLE FILE CAR
PRINT 
STRANGE_DATE
COMPUTE Y1/I4YY = STRANGE_DATE;
BY COUNTRY
END

I'm sure this is not what you're looking for.

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

October 28, 2009, 10:46 AM

Prarie

Strange_Date is right

October 28, 2009, 11:06 AM

In hurry subject line got changed.

The format I4YY solved my problem...thanks alot Francis....

regards
RP

webfocus 7.6.9 windows XP Excel