Week Of Year

[Wotan]

Is there an easy way round the 53 weeks a year Filemaker convention?

I need to allocate work weeks. When Filemaker arrives at the end of a year it counts the last week as week 53.

[LiveOak]

The way around FM's conventions is to write your own (i.e. calculate your own week number). Companies use a vast number of different standard weeks, months and quarters. It would be impossible for FM to implement them all. -bd

[dmack]

quote:

---

Originally posted by LiveOak:

The way around FM's conventions is to write your own (i.e. calculate your own week number). Companies use a vast number of different standard weeks, months and quarters. It would be impossible for FM to implement them all. -bd

---

LiveOak:

What would you need to do this?

I used this in excel... =IF((MOD(CEILING((DATECELL-"1/1/2001"+2)/7,1),52))=0,52,MOD(CEILING((DATECELL-"1/1/2001"+2)/7,1),52))

What could I do to adapt it to Filemaker?

=IF((MOD(CEILING((DATECELL-"1/1/2001"+2)/7,1),52))=0,52,MOD(CEILING((DATECELL-"1/1/2001"+2)/7,1),52))

Mod(Round((DATEFIELD-"1/1/2001"+2)/7 ,1),52) just gives a "?"...

[BobWeaver]

Try replacing "1/1/2001" with TextToDate("1/1/2001")

and use the Min function instead of the Ceiling function