Re: [Maptitude] Computing a Person's Age from a Given Date of Birth

[Chris Wagner]

well to start with  if you don't need to get  down to the day where DOB = 19691123 Add an Age field Edit >Fill   Formula 2005-value(left(string(DOB),4))      where 2005 is the year as for months and days .....  value(substring(I2S(dob),5,2))-4        where the -4  would = April     It will return a negative or positive on if the month has passed or not.    Havn't figured out how to get that to convert into the age   but it can't be far off Chris Wagner Kevin Byrnes wrote: Does anyone in the user group know of any functionality or ability within Maptitude to read the system date and update a computed "age" field based on the difference between the hard-coded Date of Birth on a client record and the system date?  I really need this capability to process a huge (5.5 million record) file and to recompute the age over time whenever the file is re-opened. The Date of Birth field is stored as an Integer (4 byte) value, with the format (e.g.)  "19691123": where 1969 = year, 11= month, 23 = day Please advise or assist if possible & many thanks in advance to anyone who can provide a solution! Thanks, Kevin Byrnes Va Dept for the Aging Yahoo! Groups Links To visit your group on the web, go to: http://groups.yahoo.com/group/Maptitude/   To unsubscribe from this group, send an email to: [EMAIL PROTECTED]   Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.