Hi All

Just a quick one.

Is it possible to test a string varibale for a specific format, e.g. Just say I have the an input box that ask for a date (UK Date) and assign it to a string var.

Dim dateVar as string

dateVar= InputBox("Please enter the date")

' the following is what I don not know

if (dateVar, "mm/dd/yyyy") = false then
   msgBox("Please enter a valid date")
end if
thanks,
mccreaso