ECTED]
Subject: RE: Access Date/Time Function
It looks like Access thinks they're integers and is trying to
divide 1 by zero indicating that they're not actually a date type(?)
You might try the IsDate() function to verify that you have a data
type of type date and then force it to date using
D]
> Subject: RE: Access Date/Time Function
>
> > I am using Access 2000. When I try to do search for the date range say,
> > from '1/1/00' to '12/1/00'. Access gives me an error saying that it's
> not
> > divisible by 00. Any help would be g
ateDiff("d", "#CreateODBCDate('1/1/00')#',
'#CreateODBCDate('12/1/00')#')#
-Original Message-
From: ldang {Lily Dang} [mailto:[EMAIL PROTECTED]]
Sent: Monday, May 15, 2000 1:19 PM
To: '[EMAIL PROTECTED]'
Subject: RE: Access Date/Time Function
> I am using Access 2000. When I try to do search for the date range say,
> from '1/1/00' to '12/1/00'. Access gives me an error saying that it's not
> divisible by 00. Any help would be greatly appreciated.
thats because the computer is trying to do the math you have put in front of
it.
1/1/
Hi All,
I am using Access 2000. When I try to do search for the date range say,
from '1/1/00' to '12/1/00'. Access gives me an error saying that it's not
divisible by 00. Any help would be greatly appreciated.
Thanks,
Lily
-
5 matches
Mail list logo