Jump to content

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


This topic is 4957 days old. Please don't post here. Open a new topic instead.

Recommended Posts

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.

Link to comment
Share on other sites

  • 2 years later...
  • Newbies

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?

Link to comment
Share on other sites

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.

Link to comment
Share on other sites

This topic is 4957 days old. Please don't post here. Open a new topic instead.

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
 Share

×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.