Code

Re: Day of week from date picker

Melli111 — Wed, 28 Dec 2011 20:07:39 GMT

Thanks Jimmy!

I actually had just found that shortly after I posted. I put my own spin on it that mixed what was in the link I orginally used with the formula in the link you provided.

Instead of having the hidden sections show the day of week I just use conditional rules to set a field to the string of the day of the week.

If hiddenDayOfWeek = 1
Action: Set dayOfWeek = Monday

I still had the rules set, I had just accidently deleted the rule that set the hiddenDayOfWeek to get the 0 - 6 value. So, I just popped that formula in from bizsupportonline and everything worked again. :)

Adding a conditional rule for 0 - 6 (Sunday - Saturday)

Thanks again Jimmy,

Melissa

Re: Day of week from date picker

Jimmy — Wed, 28 Dec 2011 19:54:57 GMT

Have you tried this:

http://www.bizsupportonline.net/infopath2007/create-week-day-infopath-form-rules-formula.htm

Re: Day of week from date picker

Melli111 — Wed, 28 Dec 2011 19:31:52 GMT

Hi Frederik,

I know this post is old, but I'm hoping that you happen to have an updated URL to the link you posted in 2009? I used the link about a year ago and it worked great, but now the blog has been deleted. Unfortunately somehow my rules got deleted and I don't remember anything about how it was done.

Thanks in advance!

Melissa

Re: Day of week from date picker

Michael Vasquez — Fri, 20 Aug 2010 14:10:18 GMT

Bad things about the rules above is that when you change the date for the first time it works but if you change again, lets say you first pick a Friday and then you want to pick a Thursday, nothing happens. If you pick a date for the next month, it works.

Re: Day of week from date picker

Michael Vasquez — Fri, 20 Aug 2010 14:08:03 GMT

substitute the quotes and minus sign with the one on your keyboard. Infopath does not like the way it is formated when you copy and paste from the Web page. You have to delete the quotes and minus sign and re-type them.

Mike

Re: Day of week from date picker

sivarao.n — Sat, 10 Jul 2010 10:59:01 GMT

Hi Frederik,

Thank a lot for your post. It's really very helpfull post.

But some how i am getting error while using below formulas.

1. Set Default Value of Field MyDay to normalize-space(substring-after(substring-after(../my:MyDate, “-”), “-”))
2. Set Default Value of Field MyMonth to normalize-space(substring-before(substring-after(../my:MyDate, “-”), “-”))
3. Set Default Value of Field MyYear to normalize-space(substring-before(../my:MyDate, “-”))

I tried like this

normalize-space(substring-after(substring-after(../my:MyDate, “-”), “-”))

and

(substring-after(substring-after(../my:MyDate, “-”), “-”))

but i am getting error like

(Unexpected character.
(substring-after(substring-after(../my:MyDate, -->“<---”), “-”))
)

(Expected value type: end-of-string

Actual value: name
Unexpected -->character.
<--(substring-after(substring-after(../my:MyDate, -->“<---”), “-”))
)

Could you Please help me how to use above formula. thanks for your help

Thanks,

Siva.

Re: Day of week from date picker

Frederik Van Lierde — Mon, 23 Nov 2009 09:23:39 GMT

It is possible codeless

The previous reply gave a link to an already codeless way of doing it, using e secondary datasource, the next link gives another solution without secondary datasources (1 formula and rules)

Have a look at http://blueinfopath.wordpress.com/2009/11/22/weekday-name-function-in-infopath/

Re: Day of week from date picker

Alec Pojidaev — Fri, 27 Feb 2009 22:03:02 GMT

If anyone interested same with no code:

http://alecpojidaev.wordpress.com/2008/12/30/infopath-codeless-programming-walkthrough-2/

Re: Day of week from date picker

Greg Collins — Wed, 07 May 2008 23:31:33 GMT

Great! Glad to hear it's working!

Re: Day of week from date picker

barmatt80 — Wed, 07 May 2008 18:17:27 GMT

thanks! that worked great. I had a data type wrong, and now all is well.

Re: Day of week from date picker

Greg Collins — Mon, 05 May 2008 22:52:08 GMT

You need to first get the text value of the date (forgive me if I write bad VB -- I'm not fluent in it):

Dim dtString as New String
dtString = thisXDocument.DOM.selectSingleNode("/dfs:myFields/my:WeekBeginning").text

Dim dt As New DateTime
dt = DateTime.Parse(dtString) ' Probably want to do some error checking here before you process the next line. Or you could use a try/catch statement.

thisXDocument.DOM.selectSingleNode("/dfs:myFields/my:DayOfweek").text = dt.DayOfWeek

Day of week from date picker

barmatt80 — Thu, 01 May 2008 17:58:43 GMT

My problem today is taking the date chosen from a date picker ("/dfs:myFields/my:Week/my:WeekBeginning") within infopath and finding the day of the week for that date. I am using vb.net language(compatible with 2003). I think it is a formatting of the xml date to the correct format for the weekday function.

I have gotten this to work:

Dim dt As New DateTime(2008, 5, 1)

thisXDocument.DOM.selectSingleNode("/dfs:myFields/my:DayOfweek").text = dt.DayOfWeek

That returns 4, then I can create a Case statement to check and enter the day. My problem is that the day isn't always may 1st, 2008, it is selected from the date picker. My ultimate goal is to verify that the day selected is a saturday, if not, show a message, and zero the date picker.

I am just at a lost today with it, any help would be appreciated.