Date Diff

[sir_dan_mitchell]

hello,

I want to work out the length of service someone has from the 1st of april 2002 to the date they enter [Enter Date]. I have tried using the Days360 function, but it wont work!

e.g. If they enter 01/05/03 then I want to know how many days they have worked for. i.e. 395 days.

Can anyone Help?

Dan

 

[smed]

Try:

DaysService: DateDiff("d",#01/04/2002#,[Enter Date])

HTH

Smed