Jump to content

  •  

UPGRADE DEADLINE - SEPTEMBER 26, 2014!
FileMaker Inc. has a deadline for users of version 10,11, 12 as Individual box or volume licenses (with expired maintenance).
If you don't renew your maintenance and upgrade to FMP 13 you will no longer be eligible to upgrade, at the discount pricing.

Volume Licensing upgrade pricing for FileMaker Pro 13, FileMaker Pro 13 Advanced and FileMaker Server 13 will be discontinued.
Individual upgrade pricing for FileMaker Pro 13 and FileMaker Pro 13 Advanced will increase after September 26, 2014.
As of 27-September-2014, FileMaker 10 products will no longer be available for purchase or support.

http://help.filemaker.com/app/answers/detail/a_id/13865


Photo

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


  • Please log in to reply
5 replies to this topic

#1 Stuart Taylor  veteran

Stuart Taylor
  • Members
  • 870 posts
  • Time Online: 25m 3s

Posted 24 February 2007 - 08:42 AM

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.

:
  • 0
• Relationships are all about ≤=x
• Some people philosopize others fill offices
• cantmove/yourwrists

#2 Stuart Taylor  veteran

Stuart Taylor
  • Members
  • 870 posts
  • Time Online: 25m 3s

Posted 24 February 2007 - 08:51 AM

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 :
  • 0
• Relationships are all about ≤=x
• Some people philosopize others fill offices
• cantmove/yourwrists

#3 Stuart Taylor  veteran

Stuart Taylor
  • Members
  • 870 posts
  • Time Online: 25m 3s

Posted 24 February 2007 - 08:55 AM

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
  • 0
• Relationships are all about ≤=x
• Some people philosopize others fill offices
• cantmove/yourwrists

#4 comment  consultant

comment
  • Members
  • 24,193 posts
  • Time Online: 329d 12h 4m 54s

Posted 24 February 2007 - 11:43 AM

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.
  • 0

#5 krust  newbie

krust
  • Newbies
  • PipPip
  • 2 posts
  • FM Application:10

Posted 06 March 2009 - 04:53 AM

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?
  • 0

#6 comment  consultant

comment
  • Members
  • 24,193 posts
  • Time Online: 329d 12h 4m 54s

Posted 06 March 2009 - 05:17 AM

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.
  • 0




FMForum Advertisers