First and last date date of Week number

[wattmhite]

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.

 

[Lee Smith]

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

[comment]

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 June 30, 2017 by comment