AnsweredAssumed Answered

Calculation based on 2 date fields

Question asked by caskew on Aug 31, 2011
Latest reply on Aug 31, 2011 by philmodjunk

Title

Calculation based on 2 date fields

Post

I making 2 tables.

One will have all of our available school dates.  Each date will have it's on unique date id.

From another table I will have:

 Student name

level1 start date, total number of days on level1

level2 start date, total number of days on level2

Total days in Program

----------------------------------------------------------------------

What is the best way to get the (total number of days on level1/level2) based on the dates table?

If they have not started level2, I would like for it to count the number of available dates between the (level1 start date) and todays date, based on available dates in the dates table .

If they have started level2, I would like for it to count the number of available dates between the (level2 start date) and todays date, based on available dates in the dates table .

And for total days in program, I would like to just add the 2 total number of days fields

Outcomes