Access Form

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. :confused:

what language?

Jason

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.