Javascript algorithm that calculates week number in Fiscal Year

Posted by ForeignerBR on Stack Overflow See other posts from Stack Overflow or by ForeignerBR
Published on 2010-05-05T02:39:16Z Indexed on 2010/05/05 2:48 UTC
Read the original article Hit count: 244

Filed under:

week-number

|

fiscal-year

|

JavaScript

Hi, I have been looking for a Javascript algorithms that gives me the week number of a given Date object within a custom fiscal year. The fiscal year of my company starts on 1 September and ends on 31 August.

Say today happens to be September 1st and I pass in a newly instanced Date object to this function; I would expect it to return 1.

Hopefully someone will be able to help me with it.

thanks,

fbr

© Stack Overflow or respective owner

Related posts about week-number

How to get week number in Python?

as seen on Stack Overflow - Search for 'Stack Overflow'
How to find out what week number is this year on June 16th (wk24) with Python? >>> More
Determine week number based on starting date

as seen on Stack Overflow - Search for 'Stack Overflow'
I need help to create a function to determine the week number based on these 2 parameters: Starting date Specified date For example, if I specify April 7, 2010 as the starting date & passed April 20, 2010 as the date to lookup, I would like the function to return WEEK 2. Another example, if… >>> More
Get entry by week number using Django ORM?

as seen on Stack Overflow - Search for 'Stack Overflow'
I tried something like: MyModel.objects.filter(year__week=1) It doesn't work. For now, I calculate the first day and the last day of the week and then use gte and lte, but it's less than efficient given that SQL comes with a Week function. >>> More
Calendar Table - Week number of month

as seen on Stack Overflow - Search for 'Stack Overflow'
I have a calendar table with data from year 2000 to 2012 (2012 wasn't intentional!). I just realize that I don't have the week number of month (e.g In January 1,2,3,4 February 1,2,3,4) How do I go about calculating the week numbers in a month to fill this table? Here is the table schema CREATE… >>> More
Problem in getting week number of sundays , in zend

as seen on Stack Overflow - Search for 'Stack Overflow'
I want to get the week number of a particular date , using Zend_Date My local is setted as English(IN) [en_IN], in Opera browser I am using the following code $date = new Zend_Date('22 Mar, 2010', null, Zend_Registry::get('Zend_Locale')); echo $date->get(Zend_Date::WEEK); //output 12, correct But… >>> More

Related posts about fiscal-year

Obtaining Current Fiscal Year from Hierarchy with MDX

as seen on Stack Overflow - Search for 'Stack Overflow'
I'm building a report in Reporting Services 2005 based on a SSAS 2005 cube. The basic idea of the report is that they want to see sales for this fiscal year to date vs. last year sales year to date. It sounds simple, but being that this is my first "real" report based on SSAS, I'm having a hell… >>> More
Fiscal year handling strategies in database design

as seen on Stack Overflow - Search for 'Stack Overflow'
By fiscal year I mean all the data in the database (in all tables) that occurred in the particular year. Lets say that we are building an application that allows user to choose from different years. What way of implementing this would you prefer, and why: Separate fiscal year data based on multiple… >>> More
Round date to fiscal year

as seen on Stack Overflow - Search for 'Stack Overflow'
The following database view rounds the date back to the closest fiscal year (April 1st): CREATE OR REPLACE VIEW FISCAL_YEAR_VW AS SELECT CASE WHEN to_number(to_char( SYSDATE, 'MM' )) < 4 THEN to_date('1-APR-'||to_char(add_months(SYSDATE, -12), 'YYYY'), 'dd-MON-yyyy') ELSE … >>> More
Time zone for Force.com API fiscal date literals?

as seen on Stack Overflow - Search for 'Stack Overflow'
I have a question about fiscal date literals in the Force.com API (http://www.salesforce.com/us/developer/docs/api/Content/sforce_api_calls_soql_select_dateformats.htm): For which time zone are date ranges calculated? For example, suppose we execute the query: SELECT Id FROM Opportunity WHERE CloseDate… >>> More
How to create database records for a financial year

as seen on Stack Overflow - Search for 'Stack Overflow'
Hello, I need to create entities (specifically contracts) in a database table that are associated with a financial year. These contracts will be applied to projects. Any contract variation will be recorded by creating a new contract record for the same financial year but the original will remain… >>> More