Missing 2 varchar Problem 1

[pgtek]

Hi
i have a field in my table definied as varchar DOB
like this 020203
i have some data that the field was not completed fill
like this 0202 missing the last 2 varchar

How can i create a formula that would check if the field is not completely fill blank all the other field and display a complet blank for this entry field?

Cheer

pg

 

[synapsevampire]

Something is lost in transalation here, but to determine if it is complete, use the len() function, as in:

len({table.field})

So a formula to blank the bad ones might be:

if len({table.field}) < 6 then
&quot;&quot;
else
{table.field}

-k

 

[pgtek]

hi
thank you my head went blank
it was so simple

tk

pg