Re: Flag particular dates
- From: "John Welch" <john(remove)welch@cal(remove)central.com>
- Date: Thu, 29 Jun 2006 17:34:48 -0700
you can use the datediff function:
datediff("w", now(),ExpDate)
will tell you the number of weeks between todays date and the expiration
date. If you want to see all records where this is less than or equal to 4,
you can put this in the criteria for the ExpDate field in a query
datediff("w", now(),ExpDate) <= 4
or you could say
datediff("w", now(),ExpDate) <= [enter number of weeks]
and it will ask you each time you run the query how many weeks you are
interested in.
for more info, look at datediff function in visual basic help. If you don't
know how to get to vb help, click on modules, in main db window, then say
new and then you should get a menu that has help.
hope this helps
"Steve" <slp@xxxxxxxxxxxxxxx> wrote in message
news:e81qis$iv$1@xxxxxxxxxxxxxxxxxxxxxxxxxxxxx
I have set up a db at work, I work in a flying school. All students and
other pilots are included in this db, along with particulars such as
Medical Certificate expiry date. I need to have the db 'flag' those people
whos medical certificates will expire in say, 4 weeks time. Any help in
setting this up would be appreciated, or perhaps if there are any
publications I could buy, I would appreciate the information. Location:
Adelaide, South Australia.
.
- References:
- Flag particular dates
- From: Steve
- Flag particular dates
- Prev by Date: Re: How to shut off ALL Menus ?
- Next by Date: Re: Why?
- Previous by thread: Flag particular dates
- Next by thread: Re: Flag particular dates
- Index(es):
Relevant Pages
|
