PC Review


Reply
Thread Tools Rate Thread

How can i calculate week endings dates in access?

 
 
=?Utf-8?B?RnJlZA==?=
Guest
Posts: n/a
 
      2nd Mar 2005
Hello,
I was just wondering how it would be possible to obtain a field called
'week ending' which would give me a list of all the sunday's dates for the
coming year.
 
Reply With Quote
 
 
 
 
David C. Holley
Guest
Posts: n/a
 
      2nd Mar 2005
The following function will give the date for the SATURDAY following the
date supplied. You'll need to adapt it to obtain Sunday's date, wich
might be as easy as adding 1, but I'm not certain and don't have time to
play with it.

weekEndingDate = DateAdd("d", myDate, (7 - DatePart("w", myDate)))

Fred wrote:
> Hello,
> I was just wondering how it would be possible to obtain a field called
> 'week ending' which would give me a list of all the sunday's dates for the
> coming year.

 
Reply With Quote
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Calculate records with dates from past week and month Teddy Microsoft Access Reports 4 16th Dec 2009 01:42 AM
How can I show dates as days of the week in Access? =?Utf-8?B?QnVuem1vbg==?= Microsoft Access Reports 1 19th May 2006 05:35 PM
How do I change numerical dates to days of week in Access =?Utf-8?B?YW5nZWxhdWNmcw==?= Microsoft Access Queries 2 6th Jul 2005 09:46 PM
calculate week days between two dates =?Utf-8?B?YmFkZXJj?= Microsoft Access Queries 2 10th Nov 2004 05:50 AM
How to calculate the week number in MS Access? Jesse Microsoft Access 2 21st Sep 2004 07:14 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 02:24 PM.