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], "Dawn Crosier" <[EMAIL PROTECTED]> 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:[EMAIL PROTECTED]
On Behalf
> Of Boehm, Gary D.
> Sent: Wednesday, September 12, 2007 7:56 AM
> To: '[email protected]'
> 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]
