Jump to content

Week Of Year


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

Recommended Posts

  • 3 months later...

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 "?"...

shocked.gif" border="0

Link to comment
Share on other sites

This topic is 8443 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
×
×
  • Create New...

Important Information

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