Try this : SET VAR AgeInYears = IFEQ(ChildBirthday,NULL,0,(.#DATE - ChildBirthday)
Although I haven't worked w/it yet, there are new(-er) functions, IFEXIST and IFNULL, which appear to work like Iif in MSVB. These might also be useful and applicable here. As I once politely told a younger classmate when he insulted mainframes, by way of the Y2K work I was doing at the time, "Hey man, whatever works, the right tool for the job." Later, Steve in Memphis > -----Original Message----- > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On > Behalf Of Patrick Murphy > Sent: Wednesday, March 20, 2002 7:44 PM > To: [EMAIL PROTECTED] > Subject: Age Variable > > > 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 > > ================================================ > 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/ > ================================================ 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/
