...

View Full Version : 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. :confused:

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.



EZ Archive Ads Plugin for vBulletin Copyright 2006 Computer Help Forum