This content has been marked as final.
Show 4 replies

1. Re: How to calculate difference b/w 2 dates
MikeNixon Dec 9, 2010 7:57 AM (in response to gaby58)1st field = recd date
2nd field = due date
3rd field = elapsed
in the elapsed field set field type = calculation then add due date  recd date.

2. Re: How to calculate difference b/w 2 dates
philmodjunk Dec 9, 2010 8:25 AM (in response to gaby58)Subtracting the date fields gives you the difference in days. To get the number of weeks you'd then divide by 7 of course.

3. Re: How to calculate difference b/w 2 dates
gaby58 Dec 9, 2010 10:16 AM (in response to gaby58)But when we divide by 7 if we get 1.5, how to represent that in weeks? can we do the calculation in table itself?

4. Re: How to calculate difference b/w 2 dates
rgnant_1 Dec 9, 2010 10:21 AM (in response to gaby58)You can format the field to any number of signifiant digits that you like. Or, you can do it in the calculation, using the "Round" number function.