財務人員知悉:轉帳支票出票日期必須大寫。手寫可直接填寫,但套印軟體若每張支票固定位置填寫大寫日期極不便。以 Access 2007 為例,提供一個通用解決思路。
Date())等欄位。Public Function Udate(mDATE As Date, mYMD As Integer) As String
' 用法:Udate(#1/2/2005#, i)
' i=1:貳零零伍(年)
' i=2:零壹(月)
' i=3:零貳(日)
' i=0:貳零零伍年零壹月零貳日(完整)
Dim i As Integer, iD As Integer
Dim strDT(2) As String, strS As String
Dim strD(0 To 9) As String * 1
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
大寫: Udate([出票日期],0)。此函數靈活支援年/月/日單獨轉換或完整日期轉換,完美解決支票列印大寫日期需求。