Sign in to follow this  
Followers 0

How long is a week? How many weeks in a year?

6 posts in this topic

Posted

Did you know that there are 53 weeks in a year and that a week can be 1 day long...

Sat 30 Dec 2006 = Week 52

Sun 31 Dec 2006 = Week 53

Mon 1 Jan 2007 = Week 1

I know its right but there goes the week view on my calendar solution.

:

Share this post


Link to post
Share on other sites

Posted

OK wikipedia explains it well

http://en.wikipedia.org/wiki/Week

1 week = 7 days = 168 hours = 10,080 minutes = 604,800 seconds (except at daylight saving time transitions or leap seconds)

1 Gregorian calendar year = 52 weeks + 1 day (2 days in a leap year)

Still its very confusing :

Share this post


Link to post
Share on other sites

Posted

The problem here for a calendar solution is that a week view is from Sun-Mon but the yearly week system begins from the 1 Jan

If the 1st Jan is not a sunday it has to say Week 53/1

hmmmm

Share this post


Link to post
Share on other sites

Posted

Actually, if you referring to Filemaker's WeekOfYear() function, there can be up to 54 weeks in a year. That's because "Fractions of weeks occurring at the beginning or end of the year count as full weeks" (if you care to read FM help, instead of or in addition to Wikipedia).

However, there's nothing to prevent you from devising any other numbering system for your weeks - it's only a matter of definition. For example, you could compare the weeknumber of Sunday and Saturday, and if they are not the same, output both.

Share this post


Link to post
Share on other sites

Posted

Actually, if you referring to Filemaker's WeekOfYear() function, there can be up to 54 weeks in a year. That's because "Fractions of weeks occurring at the beginning or end of the year count as full weeks" (if you care to read FM help, instead of or in addition to Wikipedia).

However, there's nothing to prevent you from devising any other numbering system for your weeks - it's only a matter of definition. For example, you could compare the weeknumber of Sunday and Saturday, and if they are not the same, output both.

is there any way I can define when a week starts in filemaker, so WeekOfYear() reflects it?

Share this post


Link to post
Share on other sites

Posted

Yes and no. No, you cannot change the behavior of WeekOfYear(). Yes, you can use other functions to calculate your own week-of-year. If all you need to change is the starting day of the week, use the WeekOfYearFiscal() function.

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!


Register a new account

Sign in

Already have an account? Sign in here.


Sign In Now
Sign in to follow this  
Followers 0