lcFrtpDate = "Nov 11 12:10:10 PM" lcMonthList = "JANFEBMARAPRMAYJUNJULAUGSEPOCTNOVDEC" lnYear = YEAR(DATE()) lnMonth = (AT(UPPER(LEFT(lcFtpDate,3)), lcMonthList )-1)/3+1 lnDay = VAL(SUBSTR(lcFtpDate, 5,2)) ? DATE(lnYear, lnMonth, lnDay)