Hi All,

STOP_PYMT_LOC_DT-- >> M/D/YY-->> 07/21/2015
STOP_PYMT_LOC_TM--->> HH:MM:SS format

Need to concat these two fields to get the TS,

YYMD HH:MM:SS format

Can anyone please suggest for this.

Thanks in advance..!!!

Regards,
User1

This message has been edited. Last edited by: <Kathryn Henning>,

In a DEFINE block, create a new virtual field that concatenates the two. Something like:

DEFINE FILE xyz
create any format conversion fields necessary here, then do something like: 
TIMESTAMP/A20=STOP_PYMT_LOC_DT | ' ' | STOP_PYMT_LOC_TM;

Hi,
Thanks for this...!!

Before concatenating i need to convert the date and time into alphanumeric format separately,not able to convert into alphanumeric format.

Is there any function available to convert date into alpha and time into alpha.

Thanks,
User1

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

You will have to convert things first.

See:
CONCAT docs

Hi,

Could you please tell me the functions which converts date to alpha and time to alpha.
Thanks,
User1

See the following links to get you going:

DATECVT

HCNVRT

HTIME

Don't forget my new favorite

FPRINT

It works from multiple formats to alpha