On Tue, Sep 15, 2009 at 2:12 PM, Rafael Copquin <[email protected]> wrote: > Given a week number, what function should I use to determine the range of > dates of that particular week? > > Example: today is Sep 15th, 2009 > > week( date()) = 38 > > Now, if I know the week number (week 38), how can I tell the first and last > days of that week? > > Is there a specific function in VFP or should I build my own? ----------------------------
Roll another one! It has been a long time since I did the VFP date game. Can you define what the starting # for DOW() is like you can set that in SQL Server? That is the first part of the drill to set your starting point. Is Sunday or Monday #1 Will you pass in a DATE or at least the YEAR to your function or are you just going to deal with current year? Will you accept 53 as a week # for those straggler days? 365/7 = 52.143 Do you have to deal with 4 week months and 13 month years? See why there isn't one? :) -- Stephen Russell Sr. Production Systems Programmer SQL Server DBA Web and Winform Development Independent Contractor Memphis TN 901.246-0159 _______________________________________________ Post Messages to: [email protected] Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/[email protected] ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
