I am using the three controls, Calendar, datetext, timelist and
creating a date after concatenating them and then comparing to the
User enters the information and then this is done
If Format(datetext & " " & timelist, "mm/dd/yyyy hh:mm") < Format(Now,
"mm/dd/yyyy hh:mm") Then
Msgbox "Earlier Date"
Msgbox "Later Date"
It was working fine till the dates were to be entered for 2007.
So I am selecting a date in 2007, I get earlier date in the above
How can I fix that?
Any ideas will be appreciated.