Text Box using the =DateDiff function

[HL]

Help!!!!

I am using Text box with this function in =DateDiff("n",[Equipment Start Time],[Equipment Stop Time])
The format is set to General Number

Every time it calculates the time it leaves - sign in from of the number.

Q: how do I stop this from happening…

Cheers HL

 

[llkhoutx]

You EquipmentStartTime is before (smaller than) your EquipmentStopTime, hence a negative difference. Switch the arguments to get a positive difference.

 

[mark curtis]

You could always use =Abs(DateDiff("n",[],[]))

To eliminate negatives

 

[Gram123]

Or just swap the arguments round - i.e. change the control source to:

=DateDiff("n",[Equipment Stop Time],[Equipment Start Time])

Gram