Date picker question

[kb at donovanhill]

Using InfoPath 2007, I have a timesheet form with a date picker box, the
week ending is always friday. Is there anyway to ensure that the user can
only pick a friday date? or the form warns the user if the date they selected
is not a friday?

Thanks, kevin.

 

[Kalyan G Reddy MVP (GGK Tech)]

Hello

Please read the link below, gives you an idea how to do
http://enterprise-solutions.swits.n...-sections-jscript-xdextensions&c=infopath2003

Hope it will help you

 

[Sundar Narasiman]

Kalyan,

The link you had mentioned is more towards conditional formatting. But the
person is asking
more towards client-side validation kind of things. It would be better if he
uses VSTO (Visual Studio Tools for Office)
to accomplish this task.

What do you say ??

 

[kb at donovanhill]

Thanks for your comment, I was hoping that a validation rule could help
rather than .net event to check if the date entered is a friday. Any ideas?

Thanks

 

[Sundar Narasiman]

I don't think you can achieve this with a validation rule. You need to use
C#/vb code
to handle the event and perform the necessary processing

 

[S.Y.M. Wong-A-Ton]

You can do this using data validation, rules, and formulas. I just posted an
article on how to do this. See
http://enterprise-solutions.swits.n...date-picker-infopath-using-rules-formulas.htm

 

[art.kedzierski]

You can do this using data validation, rules, and formulas. I just posted an
article on how to do this. Seehttp://enterprise-solutions.swits.net/infopath2007/force-select-day-o...

http://enterprise-solutions.swits.n...date-picker-infopath-using-rules-formulas.htm

Hmmm... I am getting different values with this formula in 2008. I'm
guessing these results are based on a 2007 calculation?

--AK

 

[S.Y.M. Wong-A-Ton]

No, it's not supposed to be, but it seems to be off by 2. Thanks for alerting
me to this bug. I'll take a closer look at it when I get a chance. In the
meantime, I've removed the article until further notice, and as mentioned
previously by another poster, this functionality can be achieved through the
use of code.

 

[S.Y.M. Wong-A-Ton]

The article is back online. I modified the formula and the numbers. It should
work fine now in 2007, 2008, and all other years. If you find any more bugs,
let me know.