Convert date string containing a month text value to a date value

Assuming you want to enter date values in the RTC client like 15-MAR-14. that won’t work. date values are only accepted with syntax like 15.03, 15.03.14, etc. But it can be that users prefer the above syntax. so then you can use a text field in your page and convert internally the value into a date value.Following function converts that kind of date string to a date value.

dateString := ’15-MAR-14′;
dateValue := ConvertDateString(dateString);
MESSAGE(FORMAT(dateValue,0,'<day,2>.<month,2>.<year4>’));

ConvertDateString(dateString : Text[9]) : Date
dateString := CONVERTSTR(dateString,’-‘,’,’);
EVALUATE(dayValue,SELECTSTR(1,dateString));
months := ‘JAN,FEB,MAR,APR,MAY,JUN,JUL,AUG,SEP,OCT,NOV,DEC';
monthValue := (STRPOS(months,SELECTSTR(2,dateString)) + 3) / 4;
EVALUATE(yearValue,SELECTSTR(3,dateString));
IF yearValue > 14 THEN
yearValue := yearValue + 1900
ELSE
yearValue := yearValue + 2000;
dateValue := DMY2DATE(dayValue,monthValue,yearValue);
exit(dateValue);

cheers