Calculate weeknumber from date - InfoPath Dev
in

InfoPath Dev

Calculate weeknumber from date

Last post 04-24-2009 03:03 AM by bram. 2 replies.
Page 1 of 1 (3 items)
Sort Posts: Previous Next
  • 04-21-2009 12:41 PM

    • bram
    • Not Ranked
    • Joined on 02-14-2007
    • Netherlands
    • Posts 8

    Calculate weeknumber from date

    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

  • 04-21-2009 01:57 PM In reply to

    Re: Calculate weeknumber from date

    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.

  • 04-24-2009 03:03 AM In reply to

    • bram
    • Not Ranked
    • Joined on 02-14-2007
    • Netherlands
    • Posts 8

    Re: Calculate weeknumber from date

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

    Kind Regards,

    Bram

Page 1 of 1 (3 items)
Copyright © 2003-2019 Qdabra Software. All rights reserved.
View our Terms of Use.