Jump to content
wattmhite

First and last date date of Week number

Recommended Posts

wattmhite    2

If using the week number function to define a field, is there a way to get the first date of week 25 (for example) and last date of week 26.

 

I'm using this for payroll so I can show on the pay slip for weeks 25 and 26 include dates June 19th - July 2nd.

 

Share this post


Link to post
Share on other sites
Lee Smith    144

I on a trip today, so all I can do is suggest a custom function Here Magic dates

Share this post


Link to post
Share on other sites
comment    1,369
Posted (edited)
1 hour ago, wattmhite said:

is there a way to get the first date of week 25

Yes, but you must also specify the year:
http://www.briandunning.com/cf/1439

Note that this assumes you're using the same method to number weeks as does Filemaker's WeekOfYear() function (most significantly, that any fraction of week occurring at the beginning of the year counts as a full week).

 

1 hour ago, wattmhite said:

and last date of week 26

The last date of week 26 is, of course, the first date of week 25 + 13.

 

 

 

Edited by comment
  • Like 1

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


×

Important Information

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