Page 1 of 1

Check to see if valid date

Posted: Thu Mar 24, 2005 3:45 pm
by jmiskey
How can I create a boolean expression to see if a part of a string I pull is a valid date? I guess I am looking for something equivalent to the VB "ISDATE" function.____For example, if I had the string:__MyString: "Today is 03/24/2005"____I would want a function that did something like:__IIF(ISDATE(CTOD(SUBSTR(MyString,10,10)),.T.,.F.)__if the ISDATE function existed in reporting writer.

=> RE: Check to see if valid date

Posted: Thu Mar 24, 2005 3:52 pm
by jmiskey
OK, I think we figured this one out ourselves, using the ERROR function, i.e.____ERROR(CTOD(SUBSTR(MyString,10,10)))__