### Title

Calculation of only days from two date fields

### Post

Hi,

I am creating a new database which would require a field the number of days between two date fields. For example:

Invoice Date 1/1/2011

Date Received 1/15/2011

Number of days: 15 (I want to calculate this field automatically if both dates above are entered)

Thanks!

Date Received - Invoice Date will compute the number of days.

You can include an if function to handle cases where both fields do not yet have a date.

If ( IsEmpty ( InvoiceDateField ) or IsEmpty ( DateReceivedField ) ; "" ; DateReceivedField - InvoiceDateField )