Focal Point
[SOLVED] Number to Month

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

October 11, 2017, 09:11 AM
RichM
[SOLVED] Number to Month
I have a database where the month is kept in a separate column. The column is populated with numbers 1 to 12

Is there a function in Webfocus that can convert 12 to December?

This message has been edited. Last edited by: FP Mod Chuck,


WebFOCUS 8
Windows, All Outputs
October 11, 2017, 09:22 AM
GamP
Other then DECODE?


GamP

- Using AS 8.2.01 on Windows 10 - IE11.
in Focus since 1988
October 11, 2017, 09:24 AM
jcannavo
Or a compute/define...something in here may help:

http://forums.informationbuild...061072742#4061072742


JC
WebFOCUS Dev Studio / App Studio
8.2.01
Windows 7
October 11, 2017, 04:00 PM
Waz
Something like this perhaps.

DEFINE FILE CAR
 MNTH/Mt = SEATS
END

TABLE FILE CAR
SUM MNTH
BY SEATS
END



Waz...

Prod:WebFOCUS 7.6.10/8.1.04Upgrade:WebFOCUS 8.2.07OS:LinuxOutputs:HTML, PDF, Excel, PPT
In Focus since 1984
Pity the lost knowledge of an old programmer!

October 12, 2017, 11:47 AM
Ian Dalton
Or a slight variation......

DEFINE FILE CAR
MNTH/Mtr = SEATS
END

TABLE FILE CAR
SUM MNTH
BY SEATS
END


_______________________
*** WebFOCUS 8.1.05M ***
October 12, 2017, 12:41 PM
jfr99
You can use FPRINT to convert to an ALPHA field ...

DEFINE FILE CAR
MNTH/Mtr = SEATS;
MNTH1/A03 = FPRINT(SEATS,'Mt',MNTH1);
MNTH2/A09 = FPRINT(SEATS,'Mtr',MNTH2);
END

TABLE FILE CAR
SUM MNTH MNTH1 MNTH2
BY SEATS
END


WebFocus 8.201M, Windows, App Studio