|
I think this question really boils down to what you consider the first week of the year. I think I remember a discussion of this a while back that indicated there is no general agreement, although there is an ISO standard: the first week of the year contains the first Thursday (I think). Does your user agree with this? If so, week #1 may or may not have a Monday and the year may or may not contain a week #52. The rest should be pretty straightforward: find out what week number the first Monday is in (by finding out what day Jan 1 falls on); subtract that number from the week number entered by the user; multiply the result by 7; add the resulting number of days to the date of the first Monday (the date functions make all this a LOT easier than it used to be :-). hth Midrange Systems Technical Discussion <midrange-l@xxxxxxxxxxxx> writes: >Hi Group, > >In my application the user would be entering the number of the week.I.e if >he enters 03 , then i would like to get Monday's date(Any format) for 3rd >week of 2003.i.e the current year(What ever is the current year) > >Thanks in advance. > >Thanks and regards >Chandra Sekhar Rath Mike Naughton Senior Programmer/Analyst Judd Wire, Inc. 124 Turnpike Road Turners Falls, MA 01376 413-863-4357 x444 mnaughton@xxxxxxxxxxxx
As an Amazon Associate we earn from qualifying purchases.
This mailing list archive is Copyright 1997-2025 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].
Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.