通过公式计算工龄
1. 使用场景
借助此例我们学习一下如何通过宜搭公式计算出工龄。
2. 实现功能
2.1 配置表单页面
![](https://yida-support.oss-cn-shanghai.aliyuncs.com/static/png/1677046871270-a3042283-0b05-466e-bcde-a211fad4b122.png)
2.2 配置字段公式
注意根据实际需求修改字段。
(1)以天折算年
![](https://yida-support.oss-cn-shanghai.aliyuncs.com/static/png/1677047031955-5a37d718-f7e1-4133-9193-398e979223cb.png)
{"text":"INT(DAYS(DATE(结束时间),DATE(开始时间))/365)","marks":[{"from":{"line":0,"ch":14,"sticky":null},"to":{"line":0,"ch":20,"sticky":null},"value":"dateField_lc0b43vm","invalid":false},{"from":{"line":0,"ch":27,"sticky":null},"to":{"line":0,"ch":33,"sticky":null},"value":"dateField_lc0b43vl","invalid":false}],"isCmData":true}
(2)以时间戳折算年
![](https://yida-support.oss-cn-shanghai.aliyuncs.com/static/png/1677047069265-1e14b40a-3685-45d6-a85e-821d15d45b85.png)
{"text":"IF(OR(ISEMPTY(开始时间),ISEMPTY(结束时间)),\"\",INT((结束时间-开始时间)/1000/60/60/24/365))","marks":[{"from":{"line":0,"ch":14,"sticky":null},"to":{"line":0,"ch":20,"sticky":null},"value":"dateField_lc0b43vl","invalid":false},{"from":{"line":0,"ch":30,"sticky":null},"to":{"line":0,"ch":36,"sticky":null},"value":"dateField_lc0b43vm","invalid":false},{"from":{"line":0,"ch":47,"sticky":null},"to":{"line":0,"ch":53,"sticky":null},"value":"dateField_lc0b43vm","invalid":false},{"from":{"line":0,"ch":54,"sticky":null},"to":{"line":0,"ch":60,"sticky":null},"value":"dateField_lc0b43vl","invalid":false}],"isCmData":true}
(3)精确计算
![](https://yida-support.oss-cn-shanghai.aliyuncs.com/static/png/1677047103368-223fa6b6-83ba-4094-a41f-1d389f5e7e28.png)
{"text":"IF(OR(ISEMPTY(开始时间),ISEMPTY(结束时间)),\"\",YEAR(DATE(YEAR(DATE(结束时间))-YEAR(DATE(开始时间))+100,MONTH(DATE(结束时间))-MONTH(DATE(开始时间))+1,DAY(DATE(结束时间))-DAY(DATE(开始时间))+2))-100)","marks":[{"from":{"line":0,"ch":14,"sticky":null},"to":{"line":0,"ch":20,"sticky":null},"value":"dateField_lc0b43vl","invalid":false},{"from":{"line":0,"ch":30,"sticky":null},"to":{"line":0,"ch":36,"sticky":null},"value":"dateField_lc0b43vm","invalid":false},{"from":{"line":0,"ch":62,"sticky":null},"to":{"line":0,"ch":68,"sticky":null},"value":"dateField_lc0b43vm","invalid":false},{"from":{"line":0,"ch":81,"sticky":null},"to":{"line":0,"ch":87,"sticky":null},"value":"dateField_lc0b43vl","invalid":false},{"from":{"line":0,"ch":105,"sticky":null},"to":{"line":0,"ch":111,"sticky":null},"value":"dateField_lc0b43vm","invalid":false},{"from":{"line":0,"ch":125,"sticky":null},"to":{"line":0,"ch":131,"sticky":null},"value":"dateField_lc0b43vl","invalid":false},{"from":{"line":0,"ch":145,"sticky":null},"to":{"line":0,"ch":151,"sticky":null},"value":"dateField_lc0b43vm","invalid":false},{"from":{"line":0,"ch":163,"sticky":null},"to":{"line":0,"ch":169,"sticky":null},"value":"dateField_lc0b43vl","invalid":false}],"isCmData":true}
3. 实现效果
![](https://yida-support.oss-cn-shanghai.aliyuncs.com/static/png/1677047158587-c87190f9-19a6-4f70-992a-c95d37b855cf.png)
4. 在线试玩
本文档对您是否有帮助?