4 Replies Latest reply on Dec 9, 2010 10:21 AM by rgnant_1

# How to calculate difference b/w 2 dates

### Title

How to calculate difference b/w 2 dates

### Post

Hi All,

We have 2 date fields recd Date and due Date, we want to have the difference b/w due Date and recd Date and it should represent in weeks, how to do this.

Thanks for any info

• ###### 1. Re: How to calculate difference b/w 2 dates

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

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

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

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.