RE: Need help from a pro
Try CreateODBCDate(Now()) Like: ... WHERE StartDate = CreateODBCDate(Now()) AND EndDate = CreateODBCDate(Now()) R. Johan -Original Message- From: Mike Weaver [mailto:[EMAIL PROTECTED]] Sent: zondag 30 juli 2000 8:08 To: [EMAIL PROTECTED] Subject: Need help from a pro This is a multi-part message in MIME format. --=_NextPart_000_0028_01BFF9B1.CB80B280 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Hello, I am in need of guidance on dates. I am using an Access db. and = have a query which generates records between 2 dates you enter in a = form. The date input for each record is the automatic access db = function. I can't seem to get the #DateFormat(Now())# to work in single or double = quotes so I used the auto function. When I run the query I get an error = of division by zero. Any assistance is greatly appreciated. Mike --=_NextPart_000_0028_01BFF9B1.CB80B280 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable !DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN" HTMLHEAD META http-equiv=3DContent-Type content=3D"text/html; = charset=3Diso-8859-1" META content=3D"MSHTML 5.50.4134.600" name=3DGENERATOR STYLE/STYLE /HEAD BODY bgColor=3D#ff DIVFONT face=3DArial size=3D2Hello,/FONT/DIV DIVFONT face=3DArial size=3D2nbsp;nbsp; I am in need of guidance = on=20 dates.nbsp;IEMnbsp; am using an Access db.nbsp; and have a query = which=20 generates records between 2 dates you enter in a form.nbsp; The date = input for=20 each record is the automatic access dbnbsp;function./EM/FONT/DIV DIVEMFONT face=3DArial size=3D2/FONT/EMnbsp;/DIV DIVEMFONT face=3DArial size=3D2I can't seem to get the = #DateFormat(Now())# to=20 work in single or double quotes so I used the auto function.nbsp; When = I run=20 the query I get an error of division by zero./FONT/EM/DIV DIVEMFONT face=3DArial size=3D2/FONT/EMnbsp;/DIV DIVEMFONT face=3DArial size=3D2Any assistance is greatly=20 appreciated./FONT/EM/DIV DIVEMFONT face=3DArial size=3D2/FONT/EMnbsp;/DIV DIVEMFONT face=3DArial = size=3D2Mike/FONT/EM/DIV/BODY/HTML --=_NextPart_000_0028_01BFF9B1.CB80B280-- -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: Need help from a pro
Haven't tried this - but can you do maths inside a query e.g. WHERE StartDate = CreateODBCDate(Now()-14) to get records from 2 weeks ago Kevin Parker Service and Communication WorkCover Corporation [EMAIL PROTECTED] ph: +61 8 82332548 fax: +61 8 82332000 -Original Message- From: Johan Coens [mailto:[EMAIL PROTECTED]] Sent: Monday, 31 July 2000 4:53:PM To: [EMAIL PROTECTED] Subject: RE: Need help from a pro Try CreateODBCDate(Now()) Like: ... WHERE StartDate = CreateODBCDate(Now()) AND EndDate = CreateODBCDate(Now()) R. Johan -Original Message- From: Mike Weaver [mailto:[EMAIL PROTECTED]] Sent: zondag 30 juli 2000 8:08 To: [EMAIL PROTECTED] Subject: Need help from a pro This is a multi-part message in MIME format. --=_NextPart_000_0028_01BFF9B1.CB80B280 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Hello, I am in need of guidance on dates. I am using an Access db. and = have a query which generates records between 2 dates you enter in a = form. The date input for each record is the automatic access db = function. I can't seem to get the #DateFormat(Now())# to work in single or double = quotes so I used the auto function. When I run the query I get an error = of division by zero. Any assistance is greatly appreciated. Mike --=_NextPart_000_0028_01BFF9B1.CB80B280 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable !DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN" HTMLHEAD META http-equiv=3DContent-Type content=3D"text/html; = charset=3Diso-8859-1" META content=3D"MSHTML 5.50.4134.600" name=3DGENERATOR STYLE/STYLE /HEAD BODY bgColor=3D#ff DIVFONT face=3DArial size=3D2Hello,/FONT/DIV DIVFONT face=3DArial size=3D2nbsp;nbsp; I am in need of guidance = on=20 dates.nbsp;IEMnbsp; am using an Access db.nbsp; and have a query = which=20 generates records between 2 dates you enter in a form.nbsp; The date = input for=20 each record is the automatic access dbnbsp;function./EM/FONT/DIV DIVEMFONT face=3DArial size=3D2/FONT/EMnbsp;/DIV DIVEMFONT face=3DArial size=3D2I can't seem to get the = #DateFormat(Now())# to=20 work in single or double quotes so I used the auto function.nbsp; When = I run=20 the query I get an error of division by zero./FONT/EM/DIV DIVEMFONT face=3DArial size=3D2/FONT/EMnbsp;/DIV DIVEMFONT face=3DArial size=3D2Any assistance is greatly=20 appreciated./FONT/EM/DIV DIVEMFONT face=3DArial size=3D2/FONT/EMnbsp;/DIV DIVEMFONT face=3DArial = size=3D2Mike/FONT/EM/DIV/BODY/HTML --=_NextPart_000_0028_01BFF9B1.CB80B280-- -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. This e-mail is intended for the use of the addressee only. It may contain information that is protected by legislated confidentiality and/or is legally privileged. If you are not the intended recipient you are prohibited from disseminating, distributing or copying this e-mail. Any opinion expressed in this e-mail may not necessarily be that of the WorkCover Corporation of South Australia. Although precautions have been taken, the sender cannot warrant that this e-mail or any files transmitted with it are free of viruses or any other defect. If you have received this e-mail in error, please notify the sender immediately by return e-mail and destroy the original e-mail and any copies. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: Need help from a pro
You'll have to used a dateadd with now and "d" and negative fourteen as parameters. then do a createodbcdate on that.. CF is really good for this type of thing. Jared. "Parker, Kevin" wrote: Haven't tried this - but can you do maths inside a query e.g. WHERE StartDate = CreateODBCDate(Now()-14) to get records from 2 weeks ago Kevin Parker Service and Communication WorkCover Corporation [EMAIL PROTECTED] ph: +61 8 82332548 fax: +61 8 82332000 -Original Message- From: Johan Coens [mailto:[EMAIL PROTECTED]] Sent: Monday, 31 July 2000 4:53:PM To: [EMAIL PROTECTED] Subject: RE: Need help from a pro Try CreateODBCDate(Now()) Like: ... WHERE StartDate = CreateODBCDate(Now()) AND EndDate = CreateODBCDate(Now()) R. Johan -Original Message- From: Mike Weaver [mailto:[EMAIL PROTECTED]] Sent: zondag 30 juli 2000 8:08 To: [EMAIL PROTECTED] Subject: Need help from a pro This is a multi-part message in MIME format. --=_NextPart_000_0028_01BFF9B1.CB80B280 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Hello, I am in need of guidance on dates. I am using an Access db. and = have a query which generates records between 2 dates you enter in a = form. The date input for each record is the automatic access db = function. I can't seem to get the #DateFormat(Now())# to work in single or double = quotes so I used the auto function. When I run the query I get an error = of division by zero. Any assistance is greatly appreciated. Mike --=_NextPart_000_0028_01BFF9B1.CB80B280 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable !DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN" HTMLHEAD META http-equiv=3DContent-Type content=3D"text/html; = charset=3Diso-8859-1" META content=3D"MSHTML 5.50.4134.600" name=3DGENERATOR STYLE/STYLE /HEAD BODY bgColor=3D#ff DIVFONT face=3DArial size=3D2Hello,/FONT/DIV DIVFONT face=3DArial size=3D2nbsp;nbsp; I am in need of guidance = on=20 dates.nbsp;IEMnbsp; am using an Access db.nbsp; and have a query = which=20 generates records between 2 dates you enter in a form.nbsp; The date = input for=20 each record is the automatic access dbnbsp;function./EM/FONT/DIV DIVEMFONT face=3DArial size=3D2/FONT/EMnbsp;/DIV DIVEMFONT face=3DArial size=3D2I can't seem to get the = #DateFormat(Now())# to=20 work in single or double quotes so I used the auto function.nbsp; When = I run=20 the query I get an error of division by zero./FONT/EM/DIV DIVEMFONT face=3DArial size=3D2/FONT/EMnbsp;/DIV DIVEMFONT face=3DArial size=3D2Any assistance is greatly=20 appreciated./FONT/EM/DIV DIVEMFONT face=3DArial size=3D2/FONT/EMnbsp;/DIV DIVEMFONT face=3DArial = size=3D2Mike/FONT/EM/DIV/BODY/HTML --=_NextPart_000_0028_01BFF9B1.CB80B280-- -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. This e-mail is intended for the use of the addressee only. It may contain information that is protected by legislated confidentiality and/or is legally privileged. If you are not the intended recipient you are prohibited from disseminating, distributing or copying this e-mail. Any opinion expressed in this e-mail may not necessarily be that of the WorkCover Corporation of South Australia. Although precautions have been taken, the sender cannot warrant that this e-mail or any files transmitted with it are free of viruses or any other defect. If you have received this e-mail in error, please notify the sender immediately by return e-mail and destroy the original e-mail and any copies. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe