Malik_Abdul_8942

CONV_DATE("DDMMYY:050517","DD-MON-YYYY") returns "05-Mai-2017" instead of "05-May-2017"

Discussion created by Malik_Abdul_8942 on Jun 22, 2017

Question:

For v11.2.2 users, we have an issue where CONV_DATE("DDMMYY:050517","DD-MON-YYYY") returns "05-Mai-2017" instead of "05-May-2017". The remaining months have the correct English 3 character abbreviation. 

Solution:

The solution is to upgrade to v11.2.3 build which appears to have fixed the issue.  However, for those still using v11.2.2 the workaround for this issue is:
:SET &QUALIFYINGDATE# = CONV_DATE("DDMMYY:050517","DD-MON-YYYY") 
:SET &QUALIFYINGDATE# = STR_SUB (&QUALIFYINGDATE#,"Mai","May") 
:PRINT &QUALIFYINGDATE#
 

Outcomes