Anniversary dates?

[jp]

I have two date fields in a table called DartDate and
ScreenDate. I need to be able to have a weekly
anniversary date and for the ScreenDate, I need a yearly
anniversary date. I need these to continually update How
do I go about doing this? I am using Access 97 and am not
very savvy.

Thanks,

John Paul

 

[Douglas J. Steele]

Not quite sure what a "weekly anniversary date" is, but assuming that you're
trying to get dates that are based on other dates, you shouldn't be storing
them in your table. Instead, you should be calculating them in a query, and
using the query wherever you would otherwise have used the table.

Let's say you have a field DateOfBirth, and you want to know when that
person's birthday is in the current year. You'd add a calculated field to
your query Birthday: DateSerial(Year(Date()), Month([DateOfBirth]),
Day([DateOfBirth])

Or let's say you've got an InvoiceDate, and you want the DueDate to be 30
days later. You'd use the DateAdd function in your query, and have DueDate:
DateAdd("d", 30, [InvoiceDate])

 

[jp]

As you can see the message you sent did not come through
(see below). Can you please resend?

 

[Douglas J. Steele]

Don't know why it's not coming through for you: I can see it fine!

I read in another group that there seems to be problems if you use the web
interface, rather than using a newsgroup reader. Unfortunately, since you
didn't post with an e-mail address, I can't copy the reply to you.

Here's what I said:

Not quite sure what a "weekly anniversary date" is, but assuming that you're
trying to get dates that are based on other dates, you shouldn't be storing
them in your table. Instead, you should be calculating them in a query, and
using the query wherever you would otherwise have used the table.

Let's say you have a field DateOfBirth, and you want to know when that
person's birthday is in the current year. You'd add a calculated field to
your query Birthday: DateSerial(Year(Date()), Month([DateOfBirth]),
Day([DateOfBirth])

Or let's say you've got an InvoiceDate, and you want the DueDate to be 30
days later. You'd use the DateAdd function in your query, and have DueDate:
DateAdd("d", 30, [InvoiceDate])


--
Doug Steele, Microsoft Access MVP

(No private e-mails, please)



--
Doug Steele, Microsoft Access MVP

(No private e-mails, please)

Not quite sure what a "weekly anniversary date" is, but assuming that you're
trying to get dates that are based on other dates, you shouldn't be storing
them in your table. Instead, you should be calculating them in a query, and
using the query wherever you would otherwise have used the table.

Let's say you have a field DateOfBirth, and you want to know when that
person's birthday is in the current year. You'd add a calculated field to
your query Birthday: DateSerial(Year(Date()), Month([DateOfBirth]),
Day([DateOfBirth])

Or let's say you've got an InvoiceDate, and you want the DueDate to be 30
days later. You'd use the DateAdd function in your query, and have DueDate:
DateAdd("d", 30, [InvoiceDate])

--
Doug Steele, Microsoft Access MVP

(No private e-mails, please)

I have two date fields in a table called DartDate and
ScreenDate. I need to be able to have a weekly
anniversary date and for the ScreenDate, I need a yearly
anniversary date. I need these to continually update How
do I go about doing this? I am using Access 97 and am not
very savvy.

Thanks,

John Paul