COBCVTDAT

Please enable JavaScript to view this site.

Zoom Window Out
Larger Text | Smaller Text
Hide Page Header
Show Expanding Text
Printable Version
Save Permalink URL

Navigation: Technical Information > Cobwebb Exit Programs > Supplied Exit Programs

COBCVTDAT

This program will take a date string in a specified format and pass it back in a different specified format. This is particularly useful in converting dates printed on a spooled file into the Cobwebb Docstore format of YYYY-MM-DD.

Parameter	In	Len	Out	Len
PARM1	Input Date String	50	Output Date String	50
PARM2	Input Date Format (optional)	7	-
PARM3	Output Date Format (optional)	50	-
PARM4	-		-
PARM5	-		-
PARM6	-		-

Note:

If no Input Date Format is specified then *DMY [DD/MM/YY] is assumed.

If no Output Date Format is specified then %Y-%m-%d {YYYY-MM-DD] is assumed which is the required format for Cobwebb Docstore.

Input Date Format string

Specifies the current format of the Input Date String to be converted. All valid date separators will be removed automatically before converting. The valid date separators are the slash (/), hyphen (-), period (.), and comma (,).

Format Code	Description
*MDY	The date has the month, day, year format, mmddyy.
*MDYY	The date has the month, day, year format, mmddyyyy.
*DMY	The date has the day, month, year format, ddmmyy.
*DMYY	The date has the day, month, year format, ddmmyyyy.
*YMD	The date has the year, month, day format, yymmdd.
*YYMD	The date has the year, month, day format, yyyymmdd.
*CYMD	The date has the century, year, month, day format, cyymmdd, where c is 0 for years 1928 through 1999 and is 1 for years 2000 through 2071.
*JUL	The date has the Julian format, yyddd.
*ISO	The date has the International Organization for Standardization (ISO) date format, yyyy-mm-dd.
*USA	The date has the United States date format, mm/dd/yyyy.
*EUR	The date has the European date format, dd.mm.yyyy.
*JIS	The date has the Japanese Industrial Standard date format, yyyy-mm-dd.
*LONGJUL	The date has the long Julian format, yyyyddd.

Example Input Date Format

If your input date is in the format mm/dd/yy you would specify *MDY as your Input Date Format in PARM2

Output Date Format string

These can be any character string value with embedded format codes. The format codes are translated into their corresponding values. These format codes and their corresponding values are listed in the table that follows.

Format Code	Description
%a	Abbreviated weekday name: 'Tue", "Wed", etc.
%A	Full weekday name: "Tuesday", "Wednesday", etc.
%b	Abbreviated month name: "Jan", "Feb", etc.
%B	Full month name: "January", "February", etc.
%d	Day of the month as a decimal (01 to 31)
%j	Day of the year as a decimal (001 to 366)
%m	Month as a decimal number (01 to 12)
%U	Week as a decimal number: Sunday base (00 to 53)
%w	Weekday as a decimal number with Sunday base (0 to 6)
%W	Week as a decimal number with Monday base (00 to 53)
%x	Date edited for local system.
%y	Year without century (2-digit year) (00 to 99)
%Y	Year with century (4-digit year)
%%	Embed a percent sign into the string.

Example Output Date Format

If you wanted your output date to be in the format Friday 29 February 2008 then you would specify %A %d %B %Y as your Output Date Format in PARM3.