List Info

Thread: -=(ASP-Support-Group)=- Re: get date from week number
-=(ASP-Support-Group)=- Re: get date from week number
user name
 2006-05-29 22:01:15 

  


  

    Hi 
Robert,

thanks for the reply - but i dont actually have a "given date" - all i 
have is the week number, and i am trying to get to a date (Sunday, for 
example)


thanks



  

  
-----Original Message-----
From: 
  ASP-Support-Group@yahoogroups.com [mailto:ASP-Support-Group@yahoogroups.com] 
  On Behalf Of Robert Davis
Sent: Monday, May 29, 2006 7:54 
  AM
To: ASP-Support-Group@yahoogroups.com
Subject: 
  -=(ASP-Support-Group)=- Re: get date from week number

Use 
  the DatePart() function to get the weekday value of the given date, 
and 
  that will tell you a number (1 - 7) that tells you which day of the 
week 
  it is. From there, just add or subtract to get the number of days 
you need 
  to add to the date to make it the day of the week that you are 
looking 
  for.

Robert.


--- In ASP-Support-Group@yahoogroups.com, 
  "Moshe Tapnack" <elists...> 
wrote:
&gt;
> Hi 
  all,
>&nbsp; 
> i know how to get a weeknumber from a date, but 
  what about getting an
> approximate date, say the first or last day of 
  the week, based on a 
given
>; week number?
&gt;  
> any 
  help appreciated!
> Thanks,
&gt; 
Moshe
>;












  

  
  
   
     
    






 [1]











   
 





about | contact  Other archives ( Real Estate discussion Medical topics )