Access Form

Dingbat · 03-21-2004, 10:50 AM

Hi Guys,

I am having a problem with a form. My need is to calculate the number of days from a given date to a given date and then to display the result in a number of days field.

Help would be greatly appreciated.

Rgards,

The Dingbat.

Jason · 03-23-2004, 01:08 AM

what language?

Jason

smeagol · 03-31-2004, 02:43 PM

Like this, using DateDiff:

The following shows the difference in days between two dates:

Dim intDays As Integer
intDays = DateDiff("d", "03-31-2004", "04-02-2004")

'Returns 2

Hope this helps.