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

List report - reference date in previous row

Started by Tseug, 07 Aug 2013 09:10:59 PM

Previous topic - Next topic

Tseug

Hello!  I have a list of people who worked various time frames over the course of many years.  So essentially each row looks like: NAME, ASSIGNMENT, START DATE, END DATE
NAME, ASSIGNMENT, START DATE, END DATE
etc

The requirement is to determine the length of time that lapsed from one assignment ending, and the next assignment beginning.

Is there any way that I can reference the END DATE of the previous row, so I can perform a days_between or something?

Thank you in advance!   8)