This content has been marked as final.
Show 4 replies

1. Re: Subtract dates using table calculation
Dylan Snyder May 22, 2013 7:15 PM (in response to Dan Wagner)Hi Dan,
I have two calculations here ... one finds the date value in the previous row using the LOOKUP function, and the other performs a DATEDIFF calculation. these could probably be combined into one calculated field, but i left them separate so it's easier to see what i did.

datediff_calc.twbx.zip 13.2 KB


2. Re: Subtract dates using table calculation
Dan Wagner May 23, 2013 7:08 AM (in response to Dylan Snyder)Hey Dylan,
I cant open up the file you sent. I'm still on version 7.0 and wont open up a file that is created with a more recent version.

3. Re: Subtract dates using table calculation
Dylan Snyder May 23, 2013 7:21 AM (in response to Dan Wagner)Here's the same thing in version 7.

datediff_calc_v7.twbx.zip 11.6 KB


4. Re: Subtract dates using table calculation
Dan Wagner May 23, 2013 7:28 AM (in response to Dylan Snyder)Great, thanks a lot Dylan