Posted: Wed Sep 01, 2010 1:33 am
Derive ACTIVITY_STATUS as
Code: Select all
If InLink.LastActivityDate < DateFromDaysSince(-365,CurrentDate()) Then "INACTIVE" Else "ACTIVE"