Thank you all for your help, I got it to work, I used #CreateODBCDate(1/1/00)# Kelly was right, Access doesn't like single quotes around dates. Thanks, Lily -----Original Message----- From: William Adamsen [mailto:[EMAIL PROTECTED]] Sent: Monday, May 15, 2000 4:16 PM To: [EMAIL PROTECTED] 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 CreateODBCDate(). <cfoutput>#DateDiff("d", "#CreateODBCDate('1/1/00')#', '#CreateODBCDate('12/1/00')#')#</cfoutput> -----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 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 ---------------------------------------------------------------------------- -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. ---------------------------------------------------------------------------- -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. ------------------------------------------------------------------------------ Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
