Browser Forms

Re: Calculate weeknumber from date

bram — Fri, 24 Apr 2009 10:03:10 GMT

Thanks Alec!
This was exaclty where i was looking for!

Kind Regards,

Bram

Re: Calculate weeknumber from date

Alec Pojidaev — Tue, 21 Apr 2009 20:57:28 GMT

I see no problem to calculate weeknumber by applying same principles as in that article:

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

the week number will be amount of days since the beginning of the first week of the year divided by 7 and rounded to the largest integer.

Calculate weeknumber from date

bram — Tue, 21 Apr 2009 19:41:26 GMT

Hello!

I searched and puzzled myself but without any luck so i hope somebody can help me with this:

I want a formula or some other way to calculate the weeknumber from a given date in infopath.

So a user selects a date in a datepicker and then a formula calculates the weeknumber. (week is 7 days, beginning in January ending in December)
The form is browser enabled so i cannot use code.

I read some articles and posts about calculating dates from weeknumbers but i want the other way around.

I hope somebody can help me with this!

Any ideas are much appreciated!

Kind regards,

Bram