Dim year As Integer
Dim month As Integer
Dim day As Integer
Dim str As String
Dim mydate As Date
year = 1999
month = 3
day = 23
str = CStr(year) & "-" & CStr(month) & "-" & CStr(day)
mydate = Format(str, "yy-mm-dd")
MsgBox mydate
Dim month As Integer
Dim day As Integer
Dim str As String
Dim mydate As Date
year = 1999
month = 3
day = 23
str = CStr(year) & "-" & CStr(month) & "-" & CStr(day)
mydate = Format(str, "yy-mm-dd")
MsgBox mydate
dim month as integer
dim day as integer
dim chargetime as date
dim Str as stringstr=year & "-" & month & "-" & day
chargetime=cdate(str)
dim month as integer
dim day as integer
dim chargetime as date
chargetime=DateSerial(year,month,day)
DateSerial(2002,4,31)=#2002-5-1#