Mac, Sorry but there is no conversion to give you the week number. There are several ways to get what you seek. However there are also several issues that need to be considered in coming up with your own function. First and foremost is the question; what is the first week of the year? Is it the partial week that includes January 1 or is it the first full week? What constitutes a full week? Does a week start on Monday or Sunday? This has been discussed on this list many times.
HTH, Gordon Gordon J. Glorfield Sr. Applications Developer UnitedHealthcare's Mid-Atlantic Health Plans 301-360-8839 [EMAIL PROTECTED] wrote on 02/16/2007 09:25:14 AM: > Hi, > Does anyone know of a oconv function to get the week no of year for a date > value. Simlair to DWA but instead of the week day, i want the week no > thanks > mac > -- > This message was scanned for spam and viruses by BitDefender. > For more information please visit http://linux.bitdefender.com/ > ------- > u2-users mailing list > u2-users@listserver.u2ug.org > To unsubscribe please visit http://listserver.u2ug.org/ This e-mail, including attachments, may include confidential and/or proprietary information, and may be used only by the person or entity to which it is addressed. If the reader of this e-mail is not the intended recipient or his or her authorized agent, the reader is hereby notified that any dissemination, distribution or copying of this e-mail is prohibited. If you have received this e-mail in error, please notify the sender by replying to this message and delete this e-mail immediately. ------- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/