三级士官
UID897144
U币0
G币567
技术0
主题0
精华0
阅读权限50
注册时间2018-6-28
最后登录2020-4-23
在线时间37 小时
三级士官
|
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") |
|