That helped, thank you.
Gary
From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of Richard
Franklin
Sent: Monday, September 17, 2007 4:28 AM
To: [email protected]
Subject: [ms_access] Re: Calculating # of days
I have set up a date field I called Test1. The expression to
determine a future date is as follows:
DayCalc: DateAdd("d",+120,[Test1]). This will return a date that is
120 days in the future. The "d" stands for day. "m" stands for month
etc.
The field name I called "Test1:" can be anything you want ,but the
function following the field name is Date().
Hope that this helps.
Dick Fr...
--- In [email protected]<mailto:ms_access%40yahoogroups.com>, Jose Luis
Mora Jr <[EMAIL PROTECTED]>
wrote:
>
> The Now() function will return the DateTime timestamp. Try Date
(). This will only return the current day.
>
> Jose
>
> Tom P <[EMAIL PROTECTED]> wrote:
> Try Now()
>
> -- "Dick Root" <[EMAIL PROTECTED]> wrote:
> I had a similar problem a few years ago. As I recall I did the data
> math in SQL
> Dick
>
> --- In [email protected]<mailto:ms_access%40yahoogroups.com>, "Dawn
> Crosier" <dlcrosier@> wrote:
> >
> > I don't believe that you can use Today() in Access. I believe
that it is
> > strictly an Excel function.
> >
> > Dawn Crosier
> > Microsoft Word MVP
> > "Education Lasts a Lifetime"
> > This message is posted to a newsgroup. Please post replies and
> questions to
> > the newsgroup so that others can learn as well.
> >
> > -----Original Message-----
> > From: [email protected]<mailto:ms_access%40yahoogroups.com>
> > [mailto:[email protected]<mailto:ms_access%40yahoogroups.com>]
> On Behalf
> > Of Boehm, Gary D.
> > Sent: Wednesday, September 12, 2007 7:56 AM
> > To: '[email protected]<mailto:%27ms_access%40yahoogroups.com>'
> > Subject: RE: [ms_access] Calculating # of days
> >
> > I tried that (WHERE (((DBA_cases.lim_date)<Today()+120))) and am
getting
> > this error:
> > [cid:image001.png@]
> > What am I missing?
> >
> >
> > No virus found in this outgoing message.
> > Checked by AVG Free Edition.
> > Version: 7.5.485 / Virus Database: 269.13.15/1003 - Release Date:
> 9/12/2007
> > 10:56 AM
> >
>
> Yahoo! Groups Links
>
> [Non-text portions of this message have been removed]
>
>
>
>
>
>
> [Non-text portions of this message have been removed]
>
[Non-text portions of this message have been removed]
