Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Dates by Number of Week
Message
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Miscellaneous
Thread ID:
00583459
Message ID:
00583645
Views:
35
>>>Hi everybody,
>>>
>>>Given 52 weeks in a year and week definition (from Sat through Friday) I need to calculate Week's first day, week's last day and some other dates for the given year for each week. What would be a formula here?
>>>
>>>Thanks a lot in advance.
>>
>>How is week 1 defined? Is the first week with a Sat, the first week with 4 or more days, the week with Jan 1?
>
>The first week could be a prior year. Say, Jan 1st is Monday, so Sat. will be Dec.30 of the previous year.

Does that the first week is defined as the week that contains Jan 1? Or the is first week with 4 days? IOW, you need to define what the first week is, from there the rest is what the others have told you.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform