Hello All, I have setup a simple test system and would like to use a Backend Function to calculate age from a date field. I have VERY LIMITED SQL experience and I have spent almost a day trying to make this work (without success). The relevant details of my system are as follows: My system is called "system"; my Relation is called "staff"; the two field which hold the relevant data are "birthdate" (DATE Field) and "age" (INTEGER). My Backend Function (which I would setup to run daily) would read the "birthdate" field in EVERY record in the "staff" Relation and then populate the "age" field in EVERY record with the calculated quantity (in years). In simple terms, age = today - birthdate; converted to whole years. I would REALLY appreciate it if someone would be kind enough to provide the EXACT Backend Function for me to achieve the above. Many Thanks, Paul
