Probs with unbound text bx on form

[Nicos67]

Hi All,

Having probs mking this expression work in an unbound text bx on a subform to work out DateDiff in days between 2 dates on form.

Error message states I have too many brackets.

Any ideas

=(Int((DateDiff('d',[Date_of_Admission],[Date_of_Discharge]))

Nicos

 

[nberryman]

( before Int and (( before Datediff



=Int(DateDiff('d',[Date_of_Admission],[Date_of_Discharge]))

Doesn't =[Date_of_Admission]- [Date_of_Discharge] give the correct value?



Neil Berryman
IT Trainer
neil_berryman@btopenworld.com

 

[Nicos67]

Thanks

Thanks for tip Neil - much appreciated

Nicos