[SOLVED] Date conversion

I'm trying to turn three text fields into a MDYY format date field. The source field is

NXTCPNDT /A20 = '2010-05-15 00:00:00'

This is what I have tried

NXTCPNMO /A2 = EDIT(NXTCPNDT,'$$$$$$$$99$$$$$$$$$$');
NXTCPNDAY /A2 = EDIT(NXTCPNDT,'$$$$$99$$$$$$$$$$$$$');
NXTCPNYEAR /A4 = EDIT(NXTCPNDT,'9999$$$$$$$$$$$$$$$$');
NXTCPN /A10 = NXTCPNMO||'/'||NXTCPNDAY||'/'||NXTCPNYEAR;
NXTCPNDT /MDYY = EDIT(NXTCPN);

I just need to assemble the three pieces and convert to MDYY to use in calculations vs other dates that are in MDYY format. Thank you for your help!

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

DevStudio 766 Servlet - Self Service - MS Windows XP SP2, (output) Excel, PDF, HTML

Posts: 12 | Registered: November 27, 2007

GamP

Virtuoso

posted

Hide Post

So close ....

NXTCPNMO /A2 = EDIT(NXTCPNDT,'$$$$$$$$99$$$$$$$$$$');
NXTCPNDAY /A2 = EDIT(NXTCPNDT,'$$$$$99$$$$$$$$$$$$$');
NXTCPNYEAR /A4 = EDIT(NXTCPNDT,'9999$$$$$$$$$$$$$$$$');
NXTCPN /A8MDYY = NXTCPNMO||NXTCPNDAY||NXTCPNYEAR;
NXTCPNDT /MDYY = NXTCPN;

GamP

- Using AS 8.2.01 on Windows 10 - IE11.
	in Focus since 1988

Posts: 1961 | Location: Netherlands | Registered: September 25, 2007

Ignored post by GamP posted

Show Post

Dan Satchell

Virtuoso

posted

Hide Post

Another approach:

NXTCPNDT/A20 = '2010-05-15 00:00:00';
DATE_HYYMDS/HYYMDS = HINPUT(14,NXTCPNDT,8,DATE_HYYMDS);
DATE_MDYY/MDYY     = HDATE(DATE_HYYMDS,'MDYY');

But, if your beginning value can be made available in a variable, you may save processing time by using Dialogue Manager to make the transformation just once, and avoid performing the transformation for every record in your table:

-SET &NXTCPNDT  = '2010-05-15 00:00:00';
-SET &DATE_MDYY = EDIT(&NXTCPNDT,'$$$$$99$') | '/' | EDIT(&NXTCPNDT,'$$$$$$$$99$') | '/' | EDIT(&NXTCPNDT,'9999$');

This message has been edited. Last edited by: Dan Satchell,

WebFOCUS 7.7.05

Posts: 1213 | Location: Seattle, Washington - USA | Registered: October 22, 2007

Ignored post by Dan Satchell posted

Show Post

Chris Austin

Member

posted

Hide Post

Thank You!!!

I'm back on track.

DevStudio 766 Servlet - Self Service - MS Windows XP SP2, (output) Excel, PDF, HTML

Posts: 12 | Registered: November 27, 2007