10-03-2008, 08:59 PM
hi
Do you want to validate the date and time or just to check if it is of the above format.
the Simplest way to do this is :
Regards
Do you want to validate the date and time or just to check if it is of the above format.
the Simplest way to do this is :
Code:
Set objRegExpr = CreateObject("VBScript.RegExp")
Environment.Value("LOB")="10/2/2008 4:24:05 PM"
If isdate(Environment.Value("LOB")) Then
msgbox "true",0
Else
msgbox "False",0
End If