If you are unable to create a new account, please email support@bspsoftware.com

 

News:

MetaManager - Administrative Tools for IBM Cognos
Pricing starting at $2,100
Download Now    Learn More

Main Menu

reagarding Dates

Started by Sreeni P, 07 Jun 2011 05:08:42 AM

Previous topic - Next topic

Sreeni P

Hi Team,

Please check this

i have to use '1.Service Award Base Date'  and '2.As of Month' basing these two i  need all your help to identify the below scenario

The employee's Service Award Base Date is 01/15/1995 while the report "As of Month" is Jan 2010, the report logic will calculate the years in between (i.e. Jan 2010 minus Jan 1995, which equals 15 years).  Then add the years to the Base Date to retrieve Next Service Award Base Date (i.e. 01/15/1995 plus 15 years, that equals 01/15/2010). 

And we need to show with Award Year 10, 15, 20, etc. (5-year increment)

If the Service Award Base Date happens to be on Feb 29 of a leap year, while the calculated Next Service Award Base Date is not in a leap year, then the Next Service Award Date will be displayed as Feb 28.  In addition, if no WRI document is submitted for the employee or if the Service Award Base Date in WRI is blanked, the employee will not be displayed in the report.