Topic Options
#46627 - 01/31/14 10:57 AM Convert Date Formatting
KP_ABD Offline
OL Newbie

Registered: 12/12/13
Posts: 25
So, I have a Date data field I am reading in:
Code:
RECORD
Alpha	letterdate      L8
redefine{
	Date	D_letterdate      L8
}

INTERNAL
Full_Letterdate     L50


In the data,
letterdate = 12312013
which makes:
D_letterdate = 12/31/2013

in my code I have:

Code:
CONVERT Full_Letterdate, D_LetterDate, ',EF '


This populates Full_Letterdate with "December 31 2013"

I need that to be: December 31, 2013

The Pres conversion is missing the comma after the day.

Top
#46664 - 02/05/14 09:42 AM Re: Convert Date Formatting [Re: KP_ABD]
Jeff_K
Unregistered


This is a known shortcoming for the DATE function to not properly insert the comma. You will need to insert one manually.


Edited by Jeff_K (02/05/14 09:42 AM)

Top