i.e., mDOB = {} >mDOB = Clinet.DOB && where the only data is 06/82 or 6/82 >mDOB = 06/01/1982 && the desired stateOne way is to build a string with the unambiguous date format {^yyyy-mm-dd} and then EVALUATE() it:
* Following assumes century is 19: * An unambiguous date will work with single-digit month and year e.g. {^1982-6-1} DateValue = EVALUATE("{^" + "19" + RIGHT(mDOB, 2) + "-" + LEFT(mDOB, LEN(mDOB) - 3) + "-" + "1" + "}")