G
Guest
Hello. I have a query and report that worked well until the situation
changed. Always the story!
Length of service was calculated by MemberDate against a given date
parameter (which was the date we threw the member length of service party).
Now, length of service needs to be calculated based on how the long the
member has been a member (novel idea!). But we still celebrate on the date of
the length of service party- if you joined the org on 02/23/06 and the party
was today (02/22/07 you would not have been a member for an entire year).
So, I think I need Diff2Dates based on the actual MemberDate and the
anniversay MemberDate, with the date of the party [Service Reference date]
thrown it. But the logic escapes me.
Here's the two statements I have that need to be altered:
Diff2Dates("ymd",[MemberDate],[Service Reference date: (MM/DD/YY)],True) AS
[Length of Service], Diff2Dates("my",[MemberDate],[Service Reference date:
(MM/DD/YY)],True) AS [Years of Service]
I'd appreciate any insight. Thanks!
changed. Always the story!
Length of service was calculated by MemberDate against a given date
parameter (which was the date we threw the member length of service party).
Now, length of service needs to be calculated based on how the long the
member has been a member (novel idea!). But we still celebrate on the date of
the length of service party- if you joined the org on 02/23/06 and the party
was today (02/22/07 you would not have been a member for an entire year).
So, I think I need Diff2Dates based on the actual MemberDate and the
anniversay MemberDate, with the date of the party [Service Reference date]
thrown it. But the logic escapes me.
Here's the two statements I have that need to be altered:
Diff2Dates("ymd",[MemberDate],[Service Reference date: (MM/DD/YY)],True) AS
[Length of Service], Diff2Dates("my",[MemberDate],[Service Reference date:
(MM/DD/YY)],True) AS [Years of Service]
I'd appreciate any insight. Thanks!