InfoPath日期选择器默认为每两个星期日 [英] InfoPath Date Picker Default to Every two Sunday

问题描述

你好，

我已经设法为日期选择器找到一个简单的代码，以将其值默认为每个星期日，但是我不知道如何在每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))

解决方案

每2个sunda的InfoPath 2013默认日期选择器

有一个演示将日期的值默认为每2个星期日.

addDays(Date，13-((number(substring(Date，9，2))+ 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(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))

解决方案

Hi InfoPath 2013 Default Date Picker to every 2 sunda,

There is a demo to default the value of the date to every 2 Sunday.

addDays(Date, 13 - ((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))

Best regards,

Sara Fan

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