LANSA Built-In Function CONVERTDATE and CONVERTDATE_NUMERIC

• CONVERTDATE Converts format of alphanumeric date.
• CONVERTDATE_NUMERIC Converts format of numeric date.

Valid Date Formats for LANSA

Input Parameters

No	Type	Req/ Opt	Description	Min Len	Max Len	Min Dec	Max Dec
1	A	Req	Date that is to be converted	1	20
2	A	Req	Format of date to be converted	1	1
3	A	Req	Format required of date in return value	1	1

Output Parameters

No	Type	Req/ Opt	Description	Min Len	Max Len	Min Dec	Max Dec
1	A	Req	Returned converted date	1	20
2	A	Opt	Return code (Y or N) for successful conversion	1	1

Sample code for LANSA Built-In Function CONVERTDATE

Convert a date field #MDY in date format MMDDYY (F) to date format YYYYMMDD (J) in field #YYMD:
USE        BUILTIN(CONVERTDATE) WITH_ARGS(#MDY F J) TO_GET(#YYMD)

Sample code for LANSA Built-In Function CONVERTDATE_NUMERIC

Convert a date field #MDY in date format MMDDYY (F) to date format YYYYMMDD (J) in field #YYMD:
USE        BUILTIN(CONVERTDATE_NUMERIC) WITH_ARGS(#MDY F J) TO_GET(#YYMD)