Focal Point
[CLOSED] CONCATENATE Date with an integer

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

December 07, 2009, 07:30 AM
adithya
[CLOSED] CONCATENATE Date with an integer
How to concatenate a DATE in YY format like 2009 to an integer I6 ,containing week number like 1,2,3,4
i want the end results like
2009 30
2009 31
2009 32....

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


WebFOCUS 7.69
Windows
Excel, HTML, PDF,AHTML
December 07, 2009, 07:43 AM
Danny-SRL
-* File Adithya2.fex
  
DEFINE FILE CAR
YR/YY WITH COUNTRY='2009';
WEEK/I2 WITH COUNTRY=52 * RDUNIF('D5.3') + 1;
YRWEEK/A7=EDIT(YR) | ' ' | EDIT(WEEK);
END
TABLE FILE CAR
PRINT YR WEEK YRWEEK
BY COUNTRY
END

This message has been edited. Last edited by: Danny-SRL,


Daniel
In Focus since 1982
wf 8.202M/Win10/IIS/SSA - WrapApp Front End for WF