Hi,
this doesnt seem to work
Dim now As Long
Dim df As String
Dim date_string As String
DateTime.DateFormat = "yyyyMMdd"
DateTime.TimeFormat = "HHmmss"
date_string=DateTime.Date(now) & "_" & DateTime.Time(now)
Msgbox("The date is: " & date_string, "")
if I do msgbox(datetime.date(now),"") etc it works. Where am I going wrong here?
this doesnt seem to work
Dim now As Long
Dim df As String
Dim date_string As String
DateTime.DateFormat = "yyyyMMdd"
DateTime.TimeFormat = "HHmmss"
date_string=DateTime.Date(now) & "_" & DateTime.Time(now)
Msgbox("The date is: " & date_string, "")
if I do msgbox(datetime.date(now),"") etc it works. Where am I going wrong here?