Re: Re: start and end date for a week

[Anonymous Monk]

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

[ChrisR]

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).