Results 1 to 3 of 3

Thread: date in access [resolved]

  1. Feb 10th, 2005, 04:10 AM #1
    bolcskei
    bolcskei is offline

    Thread Starter
    Addicted Member
    Join Date
    Nov 2004
    Location
    Lucenec, Slovakia
    Posts
    154

    Resolved date in access [resolved]

    Hi guys,

    Two days I am thinking about solvig problem with date in access. I need to work with date, but access dos not know date() function like Excel. I have database where is for every week in first column stated starting date and in the second finishing date. For example 6th week in 2005 start: 7.02.2005, end: 13.02.2005. How can I determine that date: 09.02.2005 in another table is in 6th week of the 2005 year?
    Last edited by bolcskei; Feb 14th, 2005 at 04:06 AM.
    Reply With Quote Reply With Quote
  2. Feb 11th, 2005, 11:12 AM #2
    Pasvorto
    Pasvorto is offline
    PowerPoster Pasvorto's Avatar
    Join Date
    Oct 2002
    Location
    Minnesota, USA
    Posts
    2,951

    Re: date in access

    You can use DatePart in your formula...

    Weeknumber = datepart("w",fieldname)
    Reply With Quote Reply With Quote
  3. Feb 14th, 2005, 01:30 AM #3
    bolcskei
    bolcskei is offline

    Thread Starter
    Addicted Member
    Join Date
    Nov 2004
    Location
    Lucenec, Slovakia
    Posts
    154

    Resolved Re: date in access [Resolved]

    Quote Originally Posted by Pasvorto
    You can use DatePart in your formula...

    Weeknumber = datepart("w",fieldname)
    Thanks for a clue. It should be:

    weeknumber = datepart("ww", fieldname)

    You have saved me a lot of time. It works perfectly. For more information anybody could check:
    http://www.techonthenet.com/access/f...e/datepart.htm
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules


Click Here to Expand Forum to Full Width