B
Bruce
Vendors send us certificates that have an expiration date
that could be up to four years in the future. Although
the certificates are good for several years, each year we
need to obtain verification that they are still valid.
The query includes the certificate's expiration date. I
need to send out requests for updates a month before the
certificate expiration date, so I need a query that
returns all of the vendors whose certificates are to
expire between today and one month from now. I have
already filtered out certificates that are to expire this
year, as in those cases I need to obtain the new
certificate itself rather than confirmation that the
current one is still valid. I can construct an expression
that combines the month and day from the expiration date
field with the current year (if the certificate expires on
10/1/06, the review date is 10/1/04). It looks right, but
I cannot filter it with the Between function:
Between Date() And DateAdd("m",1,Date())
The filter works on a date field, so I expect the problem
is that Access does not recognize the expression result as
a date. The expiration date field already contains the
criteria (thanks to this newsgroup):
field itself rather than the expression.
that could be up to four years in the future. Although
the certificates are good for several years, each year we
need to obtain verification that they are still valid.
The query includes the certificate's expiration date. I
need to send out requests for updates a month before the
certificate expiration date, so I need a query that
returns all of the vendors whose certificates are to
expire between today and one month from now. I have
already filtered out certificates that are to expire this
year, as in those cases I need to obtain the new
certificate itself rather than confirmation that the
current one is still valid. I can construct an expression
that combines the month and day from the expiration date
field with the current year (if the certificate expires on
10/1/06, the review date is 10/1/04). It looks right, but
I cannot filter it with the Between function:
Between Date() And DateAdd("m",1,Date())
The filter works on a date field, so I expect the problem
is that Access does not recognize the expression result as
a date. The expiration date field already contains the
criteria (thanks to this newsgroup):
I mention this in case the solution is to filter the date
field itself rather than the expression.