in reply to Re: start and end date for a week
in thread start and end date for a week

Granted, this method probably is not by any means optimal considering the simple task at hand but it will give you the results you are looking for.
MySQL's date_format is a frontend to the POSIX function strftime. Use the Perl interface to this instead of MySQL. 
use POSIX 'strftime';

# what week is December 1, 2003?
# strftime takes month-1 and year-1900 as arguments

print strftime("%U",0,0,0,1,11,103);
# or use "%V" for weeks starting Monday

[download]

Replies are listed 'Best First'.
Re: Re: Re: start and end date for a week
by ChrisR (Hermit) on Dec 01, 2003 at 22:17 UTC
    Thanks for the info. I didn't know about strftime. I'm sure I will find it useful in the future.

    As I said in my original post, I know this is not the right way to do it but it will work. So I lost a little XP for posting a workable yet unworthy answer. At least I gained real experience from it and that's why I come to PM anyway (for experience and knowledge not points or trophies).

[reply]
[d/l]

In Section Seekers of Perl Wisdom