Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

concatenat alphanumeric with time

Status
Not open for further replies.

nehapandey

Programmer
Jun 13, 2007
1
US
Hi,

I need to concatenate 2 feilds of the following format;
DAYNAME/A9 AND NEWTIME1/HHI And result should be display as Mon 16:00/Tue 08:00/Mon 09:00 etc.
 
You can ONLY concatenate ALPHA fields, so you have to first convert the time field (NEWTIME1) to alpha.

This can be done using the subroutine HCNVRT, like this:

Code:
TIMEALPHA/A8 = HCNVRT(NEWTIME1,'(HHI)',8,'A8');

Then, you can concatenate the result like any other alpha field.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top