Date Difference Calculation in Expression Builder

[apchampa]

I'm trying to add a calculated field which will be the time difference between two other date/time fields.



When I try to make a Calculated Field it does not recognize the DateDiff command.

Is there a preferred method to create a calculated field based on date/time differences? One would think this would be an easy thing to do.

Thanks for your time..... I will continue researching and testing to see if I can figure it out.

[June7]

If you want difference in days, day is default unit with simple add/subtract dates. Could try:

[datefield2] - [datefield1]

Otherwise, do calc in query or textbox.