If Blank DOB Field, Then Blank Age Field

[forskare]

I'm using this script as a function to show an age. I want to add code so that if the DOB field is empty, the age field will also be empty. (right now it shows 2002)

I've fiddled around with it (such as: if(isblank, etc.) but haven't hit on the right code. Where and what code to I add to do this?

Thanks, kenn

Age = year(date())-year(DOB)
if val(right(cdate(DOB),4)) > val(right(cdate(date()),4))
age = age - 1
end if

end function

[Fred Daniel]

RE: If Blank DOB Field, Then Blank Age Field

I'll take a stab at it. I have the same field in one of my tables. I made the DOB field required as well as the valaidation to be grater than 0. It keep people from skipping the field.

[Tom Cone Jr]

RE: If Blank DOB Field, Then Blank Age Field

Ken, I recall struggling with this some time ago. Finally reached the conclusion that in some cases an empty date field is evaluated by Alpha Five as though it has two slash marks in it, even if there are no date, month, or year values which must be separated.

i.e.  {  /  /    }

So, I used a function that would convert the date field to char string, and then another function to trim it of blanks. This 'removes' the slashes, and if the field is empty, the trim 'removes' the blanks. So, if the resulting value has a zero length the original date field is empty.

If(len(alltrim(dtos(mydatefield)))=0,"My date field is blank","My date field is not blank")

Maybe this will help in your case. -- tom

[Tom Patten]

RE: If Blank DOB Field, Then Blank Age Field

Ken,

Have you figured this out?

Try this -

Place a Calc_field on the form - just for user viewing.

Calc_field = IF(year(dob)

[forskare]

RE: If Blank DOB Field, Then Blank Age Field

TP,

I presume the 'Calc_field' part of the expression represents the name of the calculated field. If so, it can't be used until the calculated field is saved which can't be saved until a vaild field name exists. Make sense?
Kind of catch 22.

kenn

[Tom Patten]

RE: If Blank DOB Field, Then Blank Age Field

Ken,

I was assuming you had a form and on the form you defined a Calc_field with the expression above. Drop the field on the form, and when the dob field changes, the age shows and if you delete the dob field, the calc_field is blank.

Behind the scenes, if you had a calc field defined in field rules for a field in your table, that could hold 0 or number since noone would see it.

Is this not what you want or a deriaviation (sp) of this?

Tom

[forskare]

RE: If Blank DOB Field, Then Blank Age Field

Tom,

I figered it out. Slooow me. Whenever I see an expression like:

Calc_field = IF(year(dob)