This isn't really an access question as I can write the code myself(I
hope) but need to know how the start of the financial year is worked
out. If someone knows the rules or an algorithm, I would be most
grateful.
In 2001, when the 1st April 2004 was on a sunday, the first (monday to
friday) week of the financial year was the 9th to 13th April.
In 2002, the 1st was on a monday and the first week was 8th to 12th
april.
In 2003, the 1st was on a tuesday and the first week was 7th to 11th
April.
In 2004, the 1st was on a thursday, and the first week was 5th to 9th
April.
In 2005, the 1st is on a Friday, and the first week is 4th to 8th
april.
In 2006, the first is on a saturday, and the first week is the 3rd to
the 7th April.
It looks to me as if the rule is that if the
1st Day Monday of first fiscal year week
monday 8th
tuesday 7th
wednesday 6th
thursday 5th
friday 4th
saturday 3rd
sunday 13th
Is this correct or are there other factors to consider? If anyone
knows the answer or where I might find the answer, again I would be
sooooooooooo grateful.
Thanks in advance.
1  2484 
Hi,
It would seem that you should think of the weeks in terms of all 7
days. And, judging from the dates you have indicated your fiscal week
starts on a Saturday and goes thru Friday and your Fiscal Year starts
on the First Saturday of April. Consequently, the first week of 2001 is
7 thru 13 April, 2002 is 6-12, 2003 is 5-11, 2004 is 3-9, 2005 is 2-8
and 2006 is 1st to 7th of April.
JimA
This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics
by: haydn_llewellyn |
last post by:
Hi,
My company runs on a fiscal calendar that starts on the first monday in
July, and is based on a 13 week quarter (4 weeks, 4 weeks, 5 weeks).
What I need, is a way of relating Date() to the...
|
by: JohnC |
last post by:
This fantastic expression was posted by Duane Hookom. I have no idea how it
works but it displays the fiscal year and quarter for FY starting on October
1.
=Format$(DateAdd("q",1,),"\Qq...
|
by: rkohon |
last post by:
Hello all,
I am new to JavaScript and need some ideas, suggestions, or code snippets.
I have a form which requires the end user to put in a date for required items. I need javascript function to...
|
by: Twobridge |
last post by:
Hi
I am trying to perform a search that will return records based on a
fiscal year search of the bill_Date. The user gives the year then I
want to search based on the fiscal year (July 1 - June...
|
by: Sund via AccessMonster.com |
last post by:
I do fair amount of data analysis using access pivot tables and charts. Can
any body suggest a method to run the queries based on accounting month and
Accounting year.As an example: I want to...
|
by: ltazz |
last post by:
How can i make it so that Access will Recognize the fiscal year 07 start at 1 oct 2006, and end 30 Sep 2007?
i know its possible, however cant figure it out.
Thanks for the help in advance you...
|
by: shiznaw |
last post by:
I got another problem while working on this database for the Univ.
The Form.viewreports has several radial button options so that the user can
view a Report for several periods--like a day, a...
|
by: craigfr |
last post by:
I am making a graph comparing last year's defect data with YTD defect data. Our fiscal year starts Nov.1 and ends Oct.31.
To get the YTD, I started used a simple date serial criteria:
Between...
|
by: RZ15 |
last post by:
Hi guys,
I'm really drawing a blank here for how to deal with fiscal months in my monthly sales/receipts reports. My issue is that calculating the months is not as simple as saying 'if the invoice...
|
by: Charles Arthur |
last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
|
by: ryjfgjl |
last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
|
by: emmanuelkatto |
last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud.
Please let me know.
Thanks!
Emmanuel
|
by: nemocccc |
last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
|
by: Hystou |
last post by:
There are some requirements for setting up RAID:
1. The motherboard and BIOS support RAID configuration.
2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
|
by: marktang |
last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
|
by: Oralloy |
last post by:
Hello folks,
I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>".
The problem is that using the GNU compilers,...
|
by: jinu1996 |
last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...
|
by: agi2029 |
last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing,...
| |
