有个 API 是用来转换的一下子想不起来了找一下 FILETIMETOLOCALTIME 附近的函数看看
Dim Date1 As Date Dim Date2 As Date Dim Dlong As Long Dlong = 1123456789'给你的数字 Date2 = #1/1/1970# Date1 = DateAdd("s", Dlong, Date2)
正、反函数全有了,谢谢 Arcan(Arcan) ,给分! --------------------------------------------------------------------------------- Option ExplicitPrivate Sub Command1_Click() MsgBox dateN2D(1050681600) MsgBox dateD2N(dateN2D(1050681600)) End SubFunction dateN2D(ByVal numericDate As Long) As Date Dim thisDate As Date Dim baseDate As Date baseDate = #1/1/1970# thisDate = DateAdd("s", numericDate, baseDate) dateN2D = thisDate End FunctionFunction dateD2N(ByVal thisDate As Date) As Long Dim baseDate As Date baseDate = #1/1/1970# dateD2N = DateDiff("s", baseDate, thisDate) End Function
Dim Date2 As Date
Dim Dlong As Long
Dlong = 1123456789'给你的数字
Date2 = #1/1/1970#
Date1 = DateAdd("s", Dlong, Date2)
---------------------------------------------------------------------------------
Option ExplicitPrivate Sub Command1_Click()
MsgBox dateN2D(1050681600)
MsgBox dateD2N(dateN2D(1050681600))
End SubFunction dateN2D(ByVal numericDate As Long) As Date
Dim thisDate As Date
Dim baseDate As Date
baseDate = #1/1/1970#
thisDate = DateAdd("s", numericDate, baseDate)
dateN2D = thisDate
End FunctionFunction dateD2N(ByVal thisDate As Date) As Long
Dim baseDate As Date
baseDate = #1/1/1970#
dateD2N = DateDiff("s", baseDate, thisDate)
End Function