calculating from 2 dates

[Kay Davies]

Hello - can anyone help me please

I am trying to calculate the number of day's holiday
someone has taken but subtracting the end date of the
holiday from the start date.

there are two boxes

hol 1 start date
hol 1 end date

then the answer goes into an unbound box on the form which
is automatically filled in as the dates are entered.
Nothing I do seems to work so if anyone has any ideas I
would be grateful

thanks
Kay

 

[Tony C]

You need to use "DateDiff": -

HolidayDays= DateDiff("d", EndDate, StartDate)

HTH


Tony C.

 

[Kailash Kalyani]

There is a built in function called datediff function available that'll do
the subtraction for you.

you need to add an afterUpdate function to both your boxes something like

sub box1_afterupdate ()
dim result as integer
result = datediff("d", box1,box2)
box3.text = result
end sub

 

[Graham R Seach]

Kay,

Perhaps you might also find these useful:
http://www.pacificdb.com.au/MVP/Code/Age2.htm
http://www.pacificdb.com.au/MVP/Code/Diff2Dates.htm

Regards,
Graham R Seach
Microsoft Access MVP
Sydney, Australia

Microsoft Access 2003 VBA Programmer's Reference
http://www.wiley.com/WileyCDA/WileyTitle/productCd-0764559036.html