Check to see if valid date

Meeting place for R&R customers and clients to share tips and ideas. Post your questions, messages or problems here.
Post Reply
jmiskey
Posts: 46
Joined: Tue Oct 10, 2017 12:44 pm

Check to see if valid date

Post by jmiskey » Thu Mar 24, 2005 3:45 pm

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.

jmiskey
Posts: 46
Joined: Tue Oct 10, 2017 12:44 pm

=> RE: Check to see if valid date

Post by jmiskey » Thu Mar 24, 2005 3:52 pm

OK, I think we figured this one out ourselves, using the ERROR function, i.e.____ERROR(CTOD(SUBSTR(MyString,10,10)))__

Post Reply