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?
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
