[CLOSED] Date conversion

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>,

WebFOCUS 8
Windows, All Outputs

Posts: 37 | Registered: September 05, 2015

CoolGuy

Virtuoso

posted

Hide Post

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;

8.2.02M (production), 8.2.02M (test), Windows 10, all outputs.

Posts: 1113 | Location: USA | Registered: January 27, 2015

Ignored post by CoolGuy posted

Show Post

User1

Silver Member

posted

Hide Post

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,

WebFOCUS 8
Windows, All Outputs

Posts: 37 | Registered: September 05, 2015

Ignored post by User1 posted

Show Post

CoolGuy

Virtuoso

posted

Hide Post

You will have to convert things first.

See:
CONCAT docs

8.2.02M (production), 8.2.02M (test), Windows 10, all outputs.

Posts: 1113 | Location: USA | Registered: January 27, 2015