years query

[agorman]

Hi,

I would like to be able to run a query that lists the number of years members have been subscribing (up to the current year).
i.e. to show the year he joined, and how many years he has been a member (shown as a number).

Is there a way to do this easily?

thanks

Adrian

 

[ajetrumpet]

The only information I can give you is to look up the DateDiff function in the help menu. Anything further than that I cannot say because the information you have provided regarding setup, etc...is very limited. DateDiff is two values will give you the number of years members have been subscribing, given the fact that you have a record entry of somekind to indicate the date the person became a member.

 

[agorman]

Hi ajetrumpet,

I used DateDiff("yyyy",[joined],Date())
and seemed to get what I wanted

Thanks

Adrian