[SOLVED] concatenate

Focal Point

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

March 09, 2010, 09:36 AM

ramakrk

[SOLVED] concatenate

I have 2 fields,Cus_Date(MDYY) and TimestampAMPM(A10).How do i concatenate these two.I want use it in COMPUTE.
thanks for the help,
rama

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

WebFOCUS 762
Windows
To be decided(All formats)

March 09, 2010, 10:31 AM

Danny-SRL

  
COMPUTE ACUSDATE/A8DMYY=CUS_DATE;
COMPUTE RAMA/A18=ACUSDATE | TIMESTAMP;

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

March 09, 2010, 11:23 AM

ramakrk

Hi Danny,
Fantastic help.The final output is 1117200603:53:24PM.But i need 11/17/2006 03:53:24PM. A slight change. Any small hint would be appreciate.
thanks for your help,
rama

WebFOCUS 762
Windows
To be decided(All formats)

March 09, 2010, 11:46 AM

Dan Satchell

If you want the output in a date-time field instead of an alpha field, then you can do this:

DATE1/A8MDYY = Cus_Date ;
DATE2/A21 = EDIT(DATE1,'99/99/9999') | ' ' | TimestampAMPM ;
DATE3/HMDYYSA = HINPUT(21,DATE2,8,'HMDYYSA');

WebFOCUS 7.7.05

March 09, 2010, 12:00 PM

ramakrk

Dan,
I got it what i need. Very nice hint.It worked perfectly.
Thanks for the help,
rama

WebFOCUS 762
Windows
To be decided(All formats)