Date expression calculation in form

[imacamelshump]

Hey guys i need some help if got two text boxes 1 is Start Date second is Finish date.

Is there a calculation so i can have appear in another text box the duration of the project(time between start and finish) or is this not quite possible

For some reason i am drawing blanks so any help is really appreciated

 

[Nowell]

Hi,
yeah use the datediff function, do a search in the help file about the datediff function and it should give you all you need.

 

[imacamelshump]

cheers for that will do

 

[imacamelshump]

i've just looked and there is nothing on there!!!!!

 

[Nowell]

Hi,

Go into the vba editor and do a search there

 

[imacamelshump]

found it thanx a lot