[SOLVED] Retrieve last 30 calendar days and compare it with recent activity date
SL active= SLRecentActivityDate >= last 30 days and SLLockedOutFlag = āNā
I need to find the number of active employees. The logic behind that is the recent activity date should be greater than or equal to the last 30 calendar days and Lockeoutflag equal to N.
The master file contains SLRecentActivity Date and SLLockedOutFlag fields.
How to compare the recentactivity date (HYYMDI) gretaer than or equal to last 30 days?This message has been edited. Last edited by: FP Mod Chuck,
WEBFOCUS, WINDOWS, REPORTS
June 28, 2018, 01:22 PM
BabakNYC
You need to set current date and then subtract 30 days from it. Then compare your Activity Date with this new value. Start with this: