Day, month, and current year
From: Bruce (anonymous_at_discussions.microsoft.com)
Date: 09/27/04
- Next message: JonD: "lookup table for date"
- Previous message: Steve: "Re: Problems with data types"
- Next in thread: Jeff Boyce: "Re: Day, month, and current year"
- Reply: Jeff Boyce: "Re: Day, month, and current year"
- Messages sorted by: [ date ] [ thread ]
Date: Mon, 27 Sep 2004 04:28:14 -0700
My database contains expiration dates (of certificates) up
to four years in the future. If the expiration date is
during the current year, we need to request a new
certificate. In that case I have made a query that flags
everybody with a certificate that is due to expire in the
next thirty days. I run the query about weekly. If the
expiration date is not this year, we still need to obtain
confirmation that the certificate is still in effect. I
can construct (concatenate) an expression that combines
the month and day from the expiration date field with the
current year (if the certificate expires on 11/1/06, the
review date is 11/1/04, and I would send out a reminder on
10/1/04). It looks right when I run the query, but I
cannot filter it with the Between function:
Between Date() And DateAdd("m",1,Date())
This is a reworded reposting of an earlier question to
which I received no replies.
- Next message: JonD: "lookup table for date"
- Previous message: Steve: "Re: Problems with data types"
- Next in thread: Jeff Boyce: "Re: Day, month, and current year"
- Reply: Jeff Boyce: "Re: Day, month, and current year"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
