'將一個一位的數字前面加零 function FillZero(str) ttt=str iflen(str)=1then ttt="0"& str endif FillZero=ttt end function '轉化日期,將 一位補上零 2003-1-2 --> 2003-01-02 function ConvertDate(tDate) ttt=tDate ifisdate(tDate) then ttt=year(tDate) &"-"& FillZero(month(tDate)) &"-"& FillZero(day(tDate)) endif ConvertDate=ttt end function '輸入一個日期時間串,轉換成年四位,其他兩位的新的日期時間串 function ConvertDateTime(tDateTime) ttt=tDateTime ifisdate(tDateTime) then ttt=year(tDateTime) &"-"& FillZero(month(tDateTime)) &"-"& FillZero(day(tDateTime)) &""& FillZero(cstr(hour(tDateTime))) &":"& FillZero(cstr(minute(tDateTime))) &":"& FillZero(cstr(second(tDateTime))) endif ConvertDateTime=ttt end function