'Class Module 'ClsWheel'
Public Sub GetDate(Date1 As String) As String
Dim DateFormat, Date2 As String
Dim DateTicks As Long
DateFormat = DateTime.DateFormat
DateTime.DateFormat = "yyyy MMMM dd"
DateTicks = DateTime.DateParse(Date1)
DateTime.DateFormat = DateFormat
Date2 = DateTime.DATE(DateTicks)
Return Date2
End Sub
'----------------
'Main Module
sub test
msgbox(ClsWheel.DateTicks,"")
end sub