Date picker question

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

kb at donovanhill - 31 Oct 2007 02:32 GMT

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.

Signature

Reply to this Message

Kalyan G Reddy MVP (GGK Tech) - 31 Oct 2007 08:30 GMT

Hello

Please read the link below, gives you an idea how to do
http://enterprise-solutions.swits.net/infopath2003/article.php?t=switch-day-sect
ions-jscript-xdextensions&c=infopath2003

Hope it will help you

Signature

Kalyan G Reddy - INFOPATH MVP 2007
http://www.ggktech.com

> 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.

Reply to this Message

Sundar Narasiman - 31 Oct 2007 12:23 GMT

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 ??

Signature

----
Sundar Narasiman,
http://dotnetbuzz.spaces.live.com/

> Hello
>
[quoted text clipped - 9 lines]
> >
> > Thanks, kevin.

Reply to this Message

kb at donovanhill - 01 Nov 2007 00:24 GMT

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

Signature

> Kalyan,
>
[quoted text clipped - 19 lines]
> > >
> > > Thanks, kevin.

Reply to this Message

Sundar Narasiman - 01 Nov 2007 09:23 GMT

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

Signature

----
Sundar Narasiman,
http://dotnetbuzz.spaces.live.com/

> 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?
[quoted text clipped - 24 lines]
> > > >
> > > > Thanks, kevin.

Reply to this Message

S.Y.M. Wong-A-Ton - 11 Nov 2007 02:01 GMT

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.net/infopath2007/force-select-day-of-week-date
-picker-infopath-using-rules-formulas.htm
---
S.Y.M. Wong-A-Ton

Reply to this Message

art.kedzierski@gmail.com - 03 Jan 2008 15:06 GMT

> 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...
[quoted text clipped - 9 lines]
> > --
> > kb

http://enterprise-solutions.swits.net/infopath2007/force-select-day-of-week-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

Reply to this Message

S.Y.M. Wong-A-Ton - 03 Jan 2008 23:29 GMT

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

> http://enterprise-solutions.swits.net/infopath2007/force-select-day-of-week-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

Reply to this Message

S.Y.M. Wong-A-Ton - 05 Jan 2008 03:16 GMT

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.
---
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. Seehttp://enterprise-solutions.swits.net/infopath2007/force-select-day-o...
[quoted text clipped - 16 lines]
>
> --AK

Reply to this Message