|
发表于 2018-7-31 09:52:43
|
显示全部楼层
you could edit the MyMonth expression to insert a conditional expression and change the string to a numeral:
MyMonth=if(subString(MyDate, 5, 7)=="JAN")("01")ELSE IF(subString(MyDate, 5, 7)=="FEB")("02")ELSE IF(subString(MyDate, 5, 7)=="MAR")("03")ELSE IF(subString(MyDate, 5, 7)=="APR")("04")ELSE IF(subString(MyDate, 5, 7)=="MAY")("05")ELSE IF(subString(MyDate, 5, 7)=="JUN")("06")ELSE IF(subString(MyDate, 5, 7)=="JUL")("07")ELSE IF(subString(MyDate, 5, 7)=="AUG")("08")ELSE IF(subString(MyDate, 5, 7)=="SEP")("09")ELSE IF(subString(MyDate, 5, 7)=="OCT")("10")ELSE IF(subString(MyDate, 5, 7)=="NOV")("11")ELSE("12") |
|