用法

'Udate(#11/21/2005#, 0) 显示　贰零零伍年壹拾壹月贰拾壹日
'Udate(#11/21/2005#, 1) 显示　贰零零伍
'Udate(#11/21/2005#, 2) 显示　壹拾壹
'Udate(#11/21/2005#, 3) 显示　贰拾壹

Public Function Udate(mDATE As Date, mYMD As Integer) As String
   Dim i As Integer, iD As Integer
   Dim strD(0 To 9) As String * 1, strDT(2) As String, strS As String
       
      strD(0) = "零"
      strD(1) = "壹"
      strD(2) = "贰"
      strD(3) = "叁"
      strD(4) = "肆"
      strD(5) = "伍"
      strD(6) = "陆"
      strD(7) = "柒"
      strD(8) = "捌"
      strD(9) = "玖"
       
      For i = mYMD + (mYMD <> 0) To mYMD + (mYMD <> 0) - (mYMD = 0) * 2
         If i = 0 Then
            iD = Year(mDATE)
            strDT(i) = strD(iD \ 1000) & strD((iD \ 100) Mod 10) & strD((iD \ 10) Mod 10) & strD(iD Mod 10)
         Else
            If i = 1 Then iD = Month(mDATE) Else iD = Day(mDATE)
            If iD > 9 Then strS = "拾" Else strS = ""
            strDT(i) = strD(iD \ 10) & strS & strD(iD Mod 10)
            If iD > 9 And iD Mod 10 = 0 Then strDT(i) = "零" & Left$(strDT(i), 2)
         End If
      Next
       
      Select Case mYMD
         Case 0
            Udate = strDT(0) & "年" & strDT(1) & "月" & strDT(2) & "日"
         Case Else
            Udate = strDT(mYMD - 1)
      End Select
       
End Function

        
       

(责任编辑：admin)

• ·关于 Partition 函数在分组查询中的应
• ·Access算术运算符的含义和说明表
• ·mid函数的另类用法
• ·access制作程序运行进度框
• ·Function与Sub的异同（函数调用）
• ·Access判断某个数值是否为某个数据类型
• ·select case后面语句块的值的四种格式
• ·vba条件语句的两种表示方法
• ·Access几种数据类型初始化的值
• ·Access vba null与＂＂空字符串的区别
• ·access vba 数据类型表
• ·Access变量的命名规则
• ·Access中EXIT Sub与End Sub的区别
• ·Access vba中参数前关键字ByRef和ByVal
• ·Access列表框快速全选的技巧【最快】
• ·vba函数的数据类型强制转换