What is your dbms? I believe there is a known issue with the dates in specific dbms' having their start day different then that which CF expects.
Regards, Ken Smith Senior Engineer, Certified ColdFusion 5 Developer ColdFusion/Spectra Product Support (617) 219-7723 mailto:[EMAIL PROTECTED] > Macromedia DevCon 2002, October 27-30, Orlando, Florida > Learn new skills, connect with experts, be inspired. > Register by August 27, save $155, enter to win a free pass: > www.macromedia.com/go/devcon2002 -----Original Message----- From: Donovan, Jeni (Contractor) [mailto:[EMAIL PROTECTED]] Sent: Thursday, September 12, 2002 2:53 PM To: Spectra-Talk Subject: Last Updated date? This message is in MIME format. Since your mail reader does not understand this format, some or all of this message may not be legible. ------_=_NextPart_001_01C25A8D.9D6ECF6E Content-Type: text/plain; charset="iso-8859-1" Has anyone ever had a problem with the "datetimelastupdated" field when updating objects? All of my objects are being set with the "datetimelastupdated" field being two days into the future. The problem is NOT the server date on the win2K box or the database server (and it is reproduced on another box), #now()# returns the correct date. I'm using CF5, Spectra 1.51, Win2000. Any ideas?? TIA- Jeni Donovan Digicon Corporation [EMAIL PROTECTED] ------_=_NextPart_001_01C25A8D.9D6ECF6E Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN"> <HTML> <HEAD> <META HTTP-EQUIV=3D"Content-Type" CONTENT=3D"text/html; = charset=3Diso-8859-1"> <META NAME=3D"Generator" CONTENT=3D"MS Exchange Server version = 5.5.2655.35"> <TITLE>Last Updated date?</TITLE> </HEAD> <BODY> <P><FONT SIZE=3D2 FACE=3D"Arial">Has anyone ever had a problem with the = "datetimelastupdated" field when updating objects? All = of my objects are being set with the "datetimelastupdated" = field being two days into the future. The problem is NOT the = server date on the win2K box or the database server (and it is = reproduced on another box), #now()# returns the correct = date.</FONT></P> <P><FONT SIZE=3D2 FACE=3D"Arial">I'm using CF5, Spectra 1.51, = Win2000.</FONT> </P> <P><FONT SIZE=3D2 FACE=3D"Arial">Any ideas??</FONT> </P> <P><FONT SIZE=3D2 FACE=3D"Arial">TIA-</FONT> <BR><B><FONT COLOR=3D"#800000" SIZE=3D2 FACE=3D"Tahoma">Jeni = Donovan</FONT></B> <BR><FONT SIZE=3D2 FACE=3D"Tahoma">Digicon Corporation</FONT> <BR><FONT SIZE=3D2 FACE=3D"Tahoma">[EMAIL PROTECTED]</FONT> </P> </BODY> </HTML> ------_=_NextPart_001_01C25A8D.9D6ECF6E-- ______________________________________________________________________ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm ------------------------------------------------------------------------------ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/spectra_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
