DateDiff

[Dina01]

Hello I am trying to calculate the Time difference between two fields that I have in my report.

Therefore in my control source I added the following calculations.

=DateDiff("n", [HrsFin], [HrsDebut])

But I keep on getting syntax errors, that I am missing comma etc.........

Does anyone know what is wrong

Thanks in Advance

 

[3699wat]

I used the following in a textbox on a form based on your fields

=(DateDiff("n",[HrsDebut],[HrsFin]))/60

and it gives me exactly 3 hours between 11.00 AM and 2.00 PM.

All other times work also.

Good luck