Hi!

Something like following (created on the fly and did not tested it, but shows the idea)

old___error = on("error")
on error llError = .T.
llError = .F.

nMonth=val(strDate)
nDay=val(substr(strDate,len(allt(str(nMonth)))+1))
nYear=val(substr(strDate,len(allt(str(nMonth)))+1+len(allt(str(nDay)))+1))

if nYear<100
  nYear = nYear + 100*(SET("CENTURY",1)+ ;
    iif(nYear<SET("CENTURY",2),1,0) )
endif

dDate = date(nYear,nMonth,nDay)

on error &old___error
if llError
  && invalid date ...
endif

>I need to validate web data which is by default type string. The fields which are most difficult to validate are DATE type. I have written code over the years to validate such strings but I never felt satisfied that I was thorough. does anyone have any code suggestions for this validation. what I am interested in is strictly a valid date.
>
>9/14/01
>09/14/01
>09/14/2001
>01/14/09
>09-14-01
>09-14-2001
>09.14.01
>
>and on and on
>
>Thanks
>
>Glenn