HOW DO YOU WORKOUT THE TOTAL OF 2 FIELDS??

[nish]

I have two dates: HoldayBeginDate and HolidayEndDate.

How do I work out the third field which is Total Number of holiday days.

e.g. 18/06/2001 to 28/06/2001 = 20days holiday,

How do I make it automatically work out 20days or whatever without me inputting the 3rd field only the 1st and 2nd field are inputted.

Thanxs alot Nish
Systems Administrator

 

[JNC73]

Use the datediff function in sql*Server
DateDiff(Datepart, date1, date2)

Datediff substracts date1 of date2 and return a integer value.

Example

DateDiff("d", '01-01-2001', '12-01-2001')

Returns 11 days.

Hope this helps

JNC73