Caculation and Minutes function

[Victor Warner]

I have two fields with the Date & Time format. I wish to subtract one from the other. I have created a separate field, using Calculation and then using the Minutes function. But it produces no result. Using another Calculation field simply subtracting one from another produces a result in seconds.

I would like to know what I need to do t omake the Minutes function work. Attached is the Form showing how I set this up.

Attachments:

You must be logged in to view attached files.

[Cliff Richardson]

Try reversing the order: MINUTES(Start Date and Time; Finish Date and Time)

[Daniel Leu]

In my experience, often it’s the return type of the calculation operation that results in wrong results.

[Author]

Posts