Date Calculation

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Kirt84 - 17 May 2007 17:05 GMT

I have two date fields in the format of dd/mm/yyyy. I want to be able to do a
calculation where it calculates the difference between the two dates.
Therefore the output will display the number of days.

Signature

Thank you for your help

Reply to this Message

KARL DEWEY - 17 May 2007 17:07 GMT

Use DateDiff function.

Signature

KARL DEWEY
Build a little - Test a little

> I have two date fields in the format of dd/mm/yyyy. I want to be able to do a
> calculation where it calculates the difference between the two dates.
> Therefore the output will display the number of days.

Reply to this Message

Kirt84 - 17 May 2007 17:30 GMT

how does this work??

Signature

Thank you for your help

> Use DateDiff function.
>
> > I have two date fields in the format of dd/mm/yyyy. I want to be able to do a
> > calculation where it calculates the difference between the two dates.
> > Therefore the output will display the number of days.

Reply to this Message

fredg - 17 May 2007 19:42 GMT

> how does this work??

Use an unbound control on your form or report.
Set it's control source to:

=DateDiff("d",[Field1],[Field2])

This value should not be saved in any table.

Signature

Fred
Please respond only to this newsgroup.
I do not reply to personal e-mail

Reply to this Message