OK, MrC, or someone else who knows MC date and duration handling, I am still trying to find a way to get the correct age displayed for artists. MrC told me that the FormateDate(Replace(Math(Now(),/,,.)-ConvertDate([ISO date of birth]),elapsed) is no good for this purpose at the moment; it must have been this thread
http://yabb.jriver.com/interact/index.php?topic=71000.0). Now, I discovered the FormatDuration() function and found that it will return years as well, but I cannot get it to work.
This works: FormatDuration(Math(ConvertDate(1926-02-07)*86400-ConvertDate(1924-04-28)*86400))
and returns 1,78 years (my system uses comma as the decimal point).
But if I fill in the correct dates of birth and death (in ISO format which my system accepts) for Blossom Dearie I get 68,10 years which is wrong: FormatDuration(Math(ConvertDate(2009-02-07)*86400-ConvertDate(1924-04-28)*86400)).
For Nat King Cole, who died younger, it works and returns 45,95 years: FormatDuration(Math(ConvertDate(1965-02-15)*86400-ConvertDate(1919-03-17)*86400)),
Is there some kind of max limit imposed on FormatDuration() that I am hitting, or is it something else I am doing wrong? (I am aware that I am not taking leap years into account with this method.)
(Sorry if I have forgotten a reply already given, but I did try to search the forums before posting.)