两个日期/时间字段之间的差异-Lotus Notes [英] Difference between two date/time fields - Lotus Notes

问题描述

我有三个可编辑的日期/时间字段，前两个是(字段1和字段2)，样式:日历/时间控件.它们都显示时间:小时和分钟，例如:15:51.

I have three editable date/time fields which the first two is (field1 and field2), style: Calendar/time control. Both of them are showing the time: hour and minutes, eg: 15:51.

第三个字段也是(可编辑的)，我想显示field1和field2之间的区别.

The third field also (editable) which I want to show the difference between field1 and field2.

例如:如果field1为14:41，field2为14:30，则field3 = 00:11.我已经尝试过field1-field2，但是无法正常工作.该窗体具有自动刷新字段属性.谢谢！

Eg: If field1 is 14:41 and field2 is 14:30, then field3 = 00:11. I've tried field1-field2 but isn't working. The form has automatic refresh fields property. Thanks!

推荐答案

您的第三个字段需要计算，不可编辑.

Your third field needs to be computed, not editable.

如果由于某种原因它必须可编辑，并且您希望它在其他两个字段更改时进行更新，请执行以下操作:

If it HAS to be editable for some reason, and you want it to update when the other two fields are changed, do this:

创建一个新字段，并对其进行计算以进行显示和隐藏.给它一个这样的公式

Create a new field and make it computed-for-display and hidden. Give it a formula like this

@If(field1=null | field2=null; @Return(""); "");
seconds := field1-field2;
hours := @Integer(seconds/3600);
minutes := @Modulo(@Integer(seconds/60); 60);
output := @Right("00" + @Text(hours); 2) + ":" + @Right("00" + @Text(minutes); 2);
@setfield("field3"; output);
@Command([ViewRefreshFields]);
""

菲尔

这篇关于两个日期/时间字段之间的差异-Lotus Notes的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！