Calculate Week No.

Home Forum General Calculate Week No.

This topic contains 1 reply, has 0 voices, and was last updated by  sturmeyp 8 years, 1 month ago.

Viewing 2 posts - 1 through 2 (of 2 total)
  • Author
    Posts
  • #571

    sturmeyp
    Participant

    Is there a function or simple method in PF to calculate the Week Number from the current date?

    Any suggestions or help much appreciated

    Thanks

    Paul

    #5437

    There is a function in the formula editor called Date Difference. It will return the value between two dates as either:

    y – years

    l – months

    w – weeks

    d – days

    wd – working days

    h – hours

    m – minutes

    s – seconds

    If you want to know what week a day falls in (I am assuming that you are counting 52 weeks per year), use January 1 of the year as the first date and your target date as the second date. return the value in days and divide by 7 to get your result.

Viewing 2 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic.