Focal Point Banner
Community Center Education Summit Technical Support User Groups
Let's Get Social!

Facebook Twitter LinkedIn YouTube
Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     [SOLVED] Retrieve last 30 calendar days and compare it with recent activity date
Go
New
Search
Notify
Tools
Reply
  
[SOLVED] Retrieve last 30 calendar days and compare it with recent activity date
 Login/Join
 
Member
posted
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
 
Posts: 14 | Registered: May 07, 2018Reply With QuoteReport This Post
Virtuoso
posted Hide Post
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:

  
-SET &CURDATE=&YYMD;
-SET &PAST30D=AYMD(&CURDATE,-30,'I8YYMD'); 


Then in your report make sure activity date GE &PAST30D


WebFOCUS 8206, Unix, Windows
 
Posts: 1846 | Location: New York City | Registered: December 30, 2015Reply With QuoteReport This Post
Expert
posted Hide Post
Checkout DATEADD
 
Posts: 3103 | Location: Middle Tennessee | Registered: February 23, 2005Reply With QuoteReport This Post
Platinum Member
posted Hide Post
you can calculate the last 30th day's date and then put your where clause on date field,

where date Ge last 30th date and date LT current date


WF Production :- WF:8.0.0.4, 8.1.05 App-studio/Developer Studio(8.1.x) ,
8.2.0.1M , 8.2.0.2 (App-Studio8.2.x),
InfoAssist/+, InfoDiscovery
Output format:-AHTML, PDF, Excel, HTML
Platform:-Windows 7, 8,10
 
Posts: 186 | Location: Infobuild India | Registered: August 28, 2015Reply With QuoteReport This Post
  Powered by Social Strata  
 

Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     [SOLVED] Retrieve last 30 calendar days and compare it with recent activity date

Copyright © 1996-2018 Information Builders, leaders in enterprise business intelligence.