InfoPath日期选择器默认为每两个星期日

本文介绍了InfoPath日期选择器默认为每两个星期日的处理方法，对大家解决问题具有一定的参考价值，需要的朋友们下面随着小编来一起学习吧！

问题描述

你好，

我已经设法为日期选择器找到一个简单的代码，以将其值默认为每个星期日，但是我不知道如何在每2个星期日进行验证……请帮助? >

设置规则->动作->设置字段的日期选择器"

值公式"

addDays(Date，6-((number(substring(Date，9，4))+ number(number(substring(Date，1，4)))-(floor((24-number(substring(Date，1，4)) ，2)))/12)))+ floor(number(number(substring(Date，1，4))-(floor((14-number(substring(Date，6，2))))/12)))) /4) -floor(number(number(number(substring(Date，1，4)))-(floor((14-number(substring(Date，6，2)))/12)))/100)+ floor(number(number( substring(Date，1，4))-(floor((14-number(substring(Date，6，2)))/12)))/400)+ floor((31 * number(number(substring(Date，6， 6，2))+ 12 *(floor((14-number(substring(Date，6，2)))/12))-5))/12))mod 7))

解决方案

Hello,

I've managed to figure out a simple code for the date picker to default its value to every Sunday, however I can't figure out how to validate it to every 2 Sunday...Please help ?

Set Rules -> Action -> Set a field's "DATE picker"

Value Formula"

addDays(Date, 6 - ((number(substring(Date, 9, 2)) + number(number(substring(Date, 1, 4)) - (floor((24 - number(substring(Date, 6, 2))) / 12))) + floor(number(number(substring(Date, 1, 4)) - (floor((14 - number(substring(Date, 6, 2))) / 12))) / 4) - floor(number(number(substring(Date, 1, 4)) - (floor((14 - number(substring(Date, 6, 2))) / 12))) / 100) + floor(number(number(substring(Date, 1, 4)) - (floor((14 - number(substring(Date, 6, 2))) / 12))) / 400) + floor((31 * number(number(substring(Date, 6, 2)) + 12 * (floor((14 - number(substring(Date, 6, 2))) / 12)) - 5)) / 12)) mod 7))

解决方案

这篇关于InfoPath日期选择器默认为每两个星期日的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持！