At 06:43 PM 3/20/2002 -0700, you wrote: >I have this variable in a form: INTEGER Age = ((.#date - >ChildBirthday)/365). It calculates the person's age based on their >birthday. However, some records don't have a birthday entered yet so a big >number shows up instead. Anyone have an idea how to show 0 or a blank when >the column ChildBirthday is a null? > >Pat Murphy >6.5++ >[EMAIL PROTECTED] >And big fan of RBase
Pat, Try the following expression as a variable in your form. vAge = (IFNULL(ChildBirthday,0,((.#DATE-ChildBirthday)/365))) Have Fun! Very Best Regards, Razzak. ================================================ TO SEE MESSAGE POSTING GUIDELINES: Send a plain text email to [EMAIL PROTECTED] In the message body, put just two words: INTRO rbase-l ================================================ TO UNSUBSCRIBE: send a plain text email to [EMAIL PROTECTED] In the message body, put just two words: UNSUBSCRIBE rbase-l ================================================ TO SEARCH ARCHIVES: http://www.mail-archive.com/rbase-l%40sonetmail.com/
