>Hi
>I am trying to create a function in either VFP8 or transact-SQL which will accurately determine if someone is 18 years old or more.
>
>I have had a few stabs at it, but I'm sure I've seen functions in the past that have done this.
>
>Does anyone know of such code or can point me at a back issue of FPA etc.?
>
>TIA,
>Simon
Let's see if I remember. It was something like this:
? int((val(dtos(Date2)) - val(dtos(Date1))) / 10000)
should give you int(years elapsed).
Difference in opinions hath cost many millions of lives: for instance, whether flesh be bread, or bread be flesh; whether whistling be a vice or a virtue; whether it be better to kiss a post, or throw it into the fire... (from Gulliver's Travels)