Trying to get Monday's date with a known week number. - rob spijkerman - com.mysql.lists.win32

2 messages in com.mysql.lists.win32Trying to get Monday's date with a kn...

From	Sent On	Attachments
rob spijkerman	16 Feb 2003 14:47
Ignatius Reilly	17 Feb 2003 00:38

Subject:	Trying to get Monday's date with a known week number.
From:	rob spijkerman (rob....@alliedtelesyn.co.nz)
Date:	02/16/2003 02:47:02 PM
List:	com.mysql.lists.win32

Hi all

This problem is proving to be somewhat vexing.

I am trying to create a function that will return mondays date with the only
input being the known week number.

I am using MYSQL and PHP, but looking through the MYSQL Date Time functions in
the manual I cannot see any reason why I cannot derive this value with the MySQL
query itself. Does anyone have any suggestions on the best way to achieve this.

Kindest Regards

-------------------------------------------------------------

NOTICE: This message contains privileged and confidential information intended only for the use of the addressee named above. If you are not the intended recipient of this message you are hereby notified that you must not disseminate, copy or take any action in reliance on it. If you have received this message in error please notify Allied Telesyn Research Ltd immediately. Any views expressed in this message are those of the individual sender, except where the sender has the authority to issue and specifically states them to be the views of Allied Telesyn Research.