 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
MS Access Forum / Queries / July 2006Current week
Hi, Date() present today's date. How do I present today's week (which week between 1 and 52)? TIA, Tom DatePart("ww",Date())  SignatureJerry Whittle Light. Strong. Cheap. Pick two. Keith Bontrager - Bicycle Builder. > Hi, > [quoted text clipped - 4 lines] > > Tom > Hi, > [quoted text clipped - 4 lines] > > Tom Look up the DatePart function in VBA help. DatePart("ww",Date()) Also note that the DatePart function hsa various arguments to set the first week of the year as well as the first day of the week. January 1st and Sunday are the defaults. SignatureFred Please respond only to this newsgroup. I do not reply to personal e-mail Thanks for the tip, It supposed to be it, but instead of the week number I get 1/29/1900. Any ideas? Thanks, Tom >> Hi, >> [quoted text clipped - 12 lines] > first week of the year as well as the first day of the week. January > 1st and Sunday are the defaults. That appears to be the conversion of the week number to a date. Are you formatting the results of the DatePart function to a date format? > Thanks for the tip, It supposed to be it, but instead of the week number I > get 1/29/1900. [quoted text clipped - 19 lines] >> first week of the year as well as the first day of the week. January >> 1st and Sunday are the defaults. |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.