locked
Financial year and weeknumer allocation RRS feed

  • Question

  • Hi all,

    Can someone please help me with the logic to evaluate financial week number instead of calendar week number.

    For e.g. today (13.04.15) is Week 2.

    Also, 04.04.15 was week 52 and year 2014. Please note we assign the financial figures for 04.04.15 to year 2014.

    Week is from Monday to Sunday.

    Many thanks in advance.

    Monday, April 13, 2015 8:02 AM

Answers

All replies

  • So what determine start of Financial Year for you? Is it always starting from first Sunday of April in every year?

    Please Mark This As Answer if it solved your issue
    Please Vote This As Helpful if it helps to solve your issue
    Visakh
    ----------------------------
    My Wiki User Page
    My MSDN Page
    My Personal Blog
    My Facebook Page

    Monday, April 13, 2015 8:27 AM
  • 1st Monday after the end of financial year with the financial year coming to an end on a sunday.

    Week being Monday to Sunday

    Monday, April 13, 2015 8:29 AM
  • 1st Monday after the end of financial year with the financial year coming to an end on a sunday.

    Week being Monday to Sunday

    Sorry that doesnt help

    which sunday financial year will end? which month?

    You need to specify like say nth sunday of mth month etc


    Please Mark This As Answer if it solved your issue
    Please Vote This As Helpful if it helps to solve your issue
    Visakh
    ----------------------------
    My Wiki User Page
    My MSDN Page
    My Personal Blog
    My Facebook Page

    Monday, April 13, 2015 8:54 AM
  • Sorry for supplying insufficient info, financial year always starts on the 1st Monday of April.

    Can I please have a query that has following columns :-

    Week_Num, Week_Start_Date, Week_End_Date

    Thanks!

    • Edited by SweetsUK Monday, April 13, 2015 9:52 AM
    Monday, April 13, 2015 9:50 AM
    • Proposed as answer by ryguy72 Tuesday, April 14, 2015 7:07 PM
    • Marked as answer by Charlie Liao Monday, April 27, 2015 3:52 AM
    Monday, April 13, 2015 1:03 PM
  • Sorry for supplying insufficient info, financial year always starts on the 1st Monday of April.

    Can I please have a query that has following columns :-

    Week_Num, Week_Start_Date, Week_End_Date

    Thanks!

    Why not use a calendar table directly then. This will give you flexibility to define the financial year/week etc as you wish. Just have fields like FY,FYWeek etc added to table and populate it with required values as per your definition

    see

    http://visakhm.blogspot.com/2010/02/generating-calendar-table.html


    Please Mark This As Answer if it solved your issue
    Please Vote This As Helpful if it helps to solve your issue
    Visakh
    ----------------------------
    My Wiki User Page
    My MSDN Page
    My Personal Blog
    My Facebook Page


    • Edited by Visakh16MVP Monday, April 13, 2015 1:15 PM
    • Proposed as answer by ryguy72 Tuesday, April 14, 2015 7:07 PM
    • Marked as answer by Charlie Liao Monday, April 27, 2015 3:52 AM
    Monday, April 13, 2015 1:14 PM